SQL to set quantity for specific category

[jmberman]

My old code doesn't work anymore... what SQL would I run to set the quantity in category 112 to 1?

Thanks!

[mprough]

UPDATE `products` SET `products_quantity` = '1' WHERE `products`.`master_categories_id` = 112;

=)

[jmberman]

You are very kind , thank you!