Hi all!

I need to increate all prices in a Products table by say 20%. I have tried various SQL queries like

UPDATE Product_Price set Product_PRICE * 1.2

or created a new field

UPDATE Product_Price set Product_New_Price = Product_Price * 1.2

but that doesn't seem to please the gods governing MySQL

Good old days are gone where a simple dBaseIII statement like

replace all Product_Price with Product_Price * 1.2 would solve it 10 secs

Any idea anyone ?

Thanks in advance

John in sunny Brussels

the table name in your UPDATE statement was missing

UPDATE Products
SET Product_Price = Product_Price * 1.2

Thank you! This was one of the - can't remember how many - variations I hadn't tried. Will know better next time.

Have fun!