Link to home
Start Free TrialLog in
Avatar of sabecs
sabecs

asked on

MySQL - reduce column value by 1/4

Hi,
I have the following values in my MySQL table "items" with column "itemPrice" containing:

13.75

8.58,8.58,8.58,8.58,9.02,9.02,9.02,9.02

319.00

25.24,25.24,25.24,25.24,27.39,27.39,27.39,27.39,29.47,29.47,29.47,29.47

22.18

Some have multiple prices.
I need a way to reduce all prices by 1/4, is there a way I can multiply all prices by 0.75 ?

Thanks in advance
ASKER CERTIFIED SOLUTION
Avatar of Brian Tao
Brian Tao
Flag of Taiwan, Province of China image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of sabecs
sabecs

ASKER

Thanks for your comments, much appreciated.