I was hoping someone could help me figure out how to do a quick update rather than having to manually update each and every entry in the list.
I want to do something like this:
UPDATE Products SET giftwrapping = '0' WHERE product_id = ANY FROM THIS LIST BELOW
This query will be entered into phpMyadmin so I am just not sure how to construct the array like query.Any help would be greatly appreciated.
You want to use IN
UPDATE Products SET giftwrapping = '0' WHERE product_id IN (151,166,689,109,860,260,901,300,817,861,295,1,2,3)