Jerry Swanson <[EMAIL PROTECTED]> writes: > Why when I do select from database and try to compare float field with float > number, I have no results > > amount --- type float > > select * from price where amount = 3.45 // doesn't work > select * from price where amount = '3.45' //doesn't work
Floating point numbers are very rarely equal, because of small rounding errors that happen all the time. Probably the actual number in the database is something like '3.44000000000000001'. Try something like this: select * from price where amount > 3.44 and amount <= 3.46 ----Scott. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
