[eluser]slowgary[/eluser]
Maybe I'm doing something stupid but I've never seen this before. I'm trying to select a row based on a field that is a float. For some reason, I cannot do this with '=', it only works with 'LIKE'. Example:
Code:
SELECT * FROM `table` WHERE `field` = 5.5
//this returns 0 rows
SELECT * FROM `table` WHERE `field` LIKE 5.5
//this returns 1 row
Why is that? I don't like using LIKE. Thanks.