SQL Update query in PHPMyadmin

Databases
1

Hello,

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

151
166
689
109
860
260
901
300
817
861
295
1
2
3

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.

2

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)