I'm newbie in SQL questions, and today i have a big problem.
I need change many fields in my SQL, about 4,5k. But have some rules to the query change, to don't change wrong fields where don't need changed.
In table wp_postmeta i have four columns:
meta_id | post_id | meta_key | meta_value
I need change the value of
meta_value, BUT ONLY if the current value is 'Y' or 'Empty' and REPLACE to value 'X', AND ONLY in lines where
meta_key value is old_price
How i can do it?