MySQL: setting a new price factor in attributes

[enquirer66]

My knowledge of MySQL is scant. I need to be able to change the following fields:

`fws_products_attributes` WHERE `attributes_price_factor_offset` = 0.1750 so that the price factor offset = 0.20

Can anyone tell me how to do this? many thanks. Using phpMyAdmin is too slow (475 records). However, please note, not all fields contain 0.175 already some are blank
e.g. in the existing DB I have
Rows attributes_price_factor
3700 0.0000
473 0.1750
1 0.2000 (Changed this manually)

Yes, I know, backup first!

Many thanks.

[Ajeh]

You could backup your database then run in the Tools ... Install SQL Patches ...

UPDATE products_attributes SET attributes_price_factor_offset = 0.20 WHERE attributes_price_factor_offset = 0.1750;

NOTE: if you run that in phpMyAdmin, you will need to add your table prefix, if you are using them ...

[enquirer66]

Many thanks. Tried this using Tools and message read theat i statement processed but when I checked a product it still had the old figure in it. Why would that be?

[Ajeh]

Browse the products_attributes table and check that you are using the correct values and fields for the change that you want to make ...