MySQL query browser and floats?
Really stupid issue.. someone should definitely know :)
I'm using MySQL query browser, trying to select records where the field with a float variable type has a specific amount:
SELECT * FROM table WHERE amount=22.53
For some reason this doesn't return anything, even though the record definitely exists. It doesn't return anything for any other existing records with different float values. It does, however, work fine when selecting by a different field like such:
SELECT * FROM table WHERE store='walmart'.
So I'm assuming I just don't know how to enter floats in the query, eh?
I'm using MySQL query browser, trying to select records where the field with a float variable type has a specific amount:
SELECT * FROM table WHERE amount=22.53
For some reason this doesn't return anything, even though the record definitely exists. It doesn't return anything for any other existing records with different float values. It does, however, work fine when selecting by a different field like such:
SELECT * FROM table WHERE store='walmart'.
So I'm assuming I just don't know how to enter floats in the query, eh?
