Hi everyone,

I have a client who needs to change the prices of about 500 products. All of the products are currently $3.50 and they need to be changed to $4.50. All of the products are listed under one manufacturer. They do not want to change the prices of products from any other manufacturer. Is there an SQL query that they can run to change the price of all products from one manufacturer at one time?

I have this so far:
UPDATE products SET products_price=4.50 where products_price=3.50;
But the problem is it is not limited to a specific manufacturer, so it will change the price of ALL products that are currently $3.50. I'm not sure what I need to add to make it work...

Can anyone help?

Thank you!