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.