SQL help

[warleb]

Trying to run an SQL to update all products on a certain manufacturer to be out of stock. but it throws up errors. I do know SQL but it must be different on this platform. Can anyone point me in the right direction..

 

 

SELECT * FROM `products` SET `products_status` = 0 WHERE `manufacturers_id` = 106

 

 

Cheers

Steve

[kagg]

update products set products_status='0' where manufacturers_id='106';