Thread: mysql rounding help
View Single Post
  #3 (permalink)  
Old 07-03-09, 06:37 PM
Jcbones Jcbones is offline
Aspiring Coder
  
Join Date: Mar 2009
Location: North Carolina, USA
Posts: 414
Thanks: 4
Thanked 27 Times in 26 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