I would like to set the values of all items in master category 1 for metatags_model_status to all = 0
I have some other values I want changed as well. But this information should get me started.
I tried some variations of the below syntax without success
SELECT * FROM `znc_products` WHERE `master_categories_id` = 1
SET metatags_model_status = replace(metatags_model_status,'1','0');
Further to this, I would like to update all the meta keywords and such for all items in master category 1
Yes, I have backed up my DB