bulk update price

[maria82g]

I want to change prices of products marked at $22 to $25 I am using this

UPDATE products SET products_price = 25 WHERE products_price = 22; ,


but prices are not changing.... umm any idea?


all my products are priced by attributes

if SQL is not the answer to this, then is there any other solution?

Thanks

[maria82g]

YAY!!!!!!!! did it!!!
UPDATE products_attributes SET options_values_price = '25.0000' WHERE options_values_price = '22.0000';