Unless I misunderstand your intent, I don't think you want to SUM the values. That'll basically add them all together, resulting in a single value. Is that what you want to do, or....?
Quote:
Originally Posted by 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.
|