Thread: mysql rounding help
View Single Post
  #3 (permalink)  
Old 07-03-09, 07:37 PM
Jcbones Jcbones is offline
Coding Addict
  
Join Date: Mar 2009
Location: North Carolina, USA
Posts: 280
Thanks: 3
Thanked 5 Times in 5 Posts
Your query should probably be.

Code:
UPDATE `ic_option_values` 
SET `price_change` = ROUND(`price_change` * 1.55) 
WHERE `price_change`!=0
Reply With Quote