SQL query needed

[buildingblocks]

I have a mod installed to include the condition of my items. I want to run an sql patch to update the products all at once to all have the same condition set as used. Then I can go back and revise the very few items that are new. I updated one product in phpmyadmin and have this sql patch

UPDATE `username_zc1`.`zen_products` SET `products_condition` = 'used' WHERE `zen_products`.`products_id` =5;

Can this code be adjusted so I can run it to change all products_condition at once?

[Ajeh]

If you do not limit it with the WHERE clause then ALL Products in the products table will get updated with that ...

[buildingblocks]

so would this be correct?

UPDATE `username_zc1`.`zen_products` SET `products_condition` = 'used';

[Ajeh]

Or, if you want to run it from your Zen Cart Admin, you can use the Tools ... Install SQL Patches ... using:

UPDATE products SET products_condition = 'used';

[buildingblocks]

Great! Thank you :-)