Mysql and money: precision problems with FLOAT(10,2)
Known problem with IEEE floats.  Use DECIMAL

To fix


add new column of correct data type
copy data over (check for conversion errors here)
drop bad column
rename new column to correct name


Why?  Murphy's Law.