[Regan Shepherd]

Hi,

I'm new to mysql I'm try to do this… see below.
I don't need any PHP code as I'm just trying to update the database via mysql with an sql query.

From the table ic_option_values
Select all of the price_change values that are not equal to 0.
Multiply these by 1.55
Round the values to the nearest whole number

Don't laugh… here's my attempt.

UPDATE *
FROM `ic_option_values`
WHERE `price_change` !=0
SUM(`price_change`* 1.55)
ROUND (`price_change`, 0)

Any help would be most appreciated.