I am in need of changing multiple records in my database. I'm new to this so if someone would look at what I have figured out so far through my research and let me know if this looks correct I would appreciate it.
I have few thousand fields that contain "0" and I need to remove every "0" so it to contains nothing. So I ran a query to find them all.
WHERE `meta_key` = '_regular_price'
AND `meta_value` = '0'
UPDATE `wp_postmeta` SET `meta_value` = '' WHERE `meta_value` =0;
Ok I just tried out the following
UPDATE `wp_postmeta` SET `meta_value` = '' WHERE `meta_key` = '_regular_price' AND `meta_value` = '0';
And it worked!
So using this I was able to update multiple rows of a table in one column to contain a blank value not a NULL value but a blank value. It updated 3562 records and left the other records alone.
Thanks for everyone's advice and tips and help they helped lead me in the right direction.