SQL for price updates

[Yahalimu]

Hi,

To increase all products by certain percentage per manufacturer in PhpMyAdmin is simple and has been covered before:
eg.

update `products` set `products_price` = (`products_price` * '1.05') WHERE `manufacturers_id` = '23';

Alas this only fully works with un-attributed products.
'products_attributes' does not have the manufacturer_id as a column as its in 'products'.

Any suggestions on how the above SQL query be changed, so as to also increase the attributes by the set percentage? (of the manufacturers products)

[zipurman]

Make sure you backup your database first, but the following should work:

update products_attributes SET options_values_price = (options_values_price * 1.05) WHERE products_id IN (SELECT products_id FROM products WHERE manufacturers_id = 23);