getting float values from mysql table
Posted: Mon Apr 25, 2005 10:35 am
i have one fields stored in table of type float(3,2). this stores float values like 2.99. but what i cant understand is that if i try to select the row with the value 2.99 using this piece of SQL code for example:
it returns nothing, even though i know that 2.99 is one of the fields in the table. anyone know why this is?? and what i can do to correct it...
Code: Select all
select * from table where value = '2.99'