mysql query on float values

[ndorfnz]

This one seems all too easy, but yet causing a lot of grief!!

Simple querying a values on a float column (distance) defined with 2 decimals.

Let's take for example the value 26.2

The following query DOES NOT return anything.

select * from races where distance = 26.2

The following returns this record

select * from races where distance like 26.2

However, I then DO NOT return the following when using like

select * from races where distance like 5

Appreciate any input!!!!!

[leatherback]

Hm, Dunno, but..
perhaps you need to do some rounding on the float colum (In the query of course!)

how about trying:
select * from races where round(distance,1) = 26.2

[ndorfnz2]

Gave it a shot, still doesn't completely work correctly!

Appears there is an issue with this...

http://www.mysql.com/doc/en/Problems_with_float.html

Curious how others have handled...

Here's my SELECT statement...

$querydetail = "SELECT *, DATE_FORMAT(rundate,'%W, %M %d, %Y') as wdate from races where workout_type = 'Race' and distance = $distancesel order by rundate DESC

Tried format(distance,2) = format($distancesel,2) but did not work either.

Tried to modfiy using mysql.com resolution, but couldn't get it figured out!!!

Sincerely appreciate any feedback. This is the final issue with my long awaited program!!!!