SQL: Update table where column = Multiple Values

Question

I created an SQL query which updates a table column where another column = value

CODE:

Update Products Set ProductName = 'Shoes' WHERE ProductID = (1,2,3,4,5,6,7,8)

The problem is with the ProductID. How can I make it update the column with those ID's ?

Regards.

Answer 1

Replace ProductID = with ProductID IN

Update Products 
Set ProductName = 'Shoes' 
WHERE ProductID IN (1,2,3,4,5,6,7,8) 

Answer 2

You just use "IN":

Update Products Set ProductName = 'Shoes' WHERE ProductID in (1,2,3,4,5,6,7,8)