mysql float data not selecting in where clause

Question

This maybe an easy one but i couldn't get answer. I need to select float value from table

example table :-

value
10.2
4.5
4.6
4.06

my query

SELECT * FROM table where value = '4.6'

returns empty result set

how can i solve this !

Answer 1

You can also try query

SELECT * FROM table WHERE value LIKE 4.6;

Answer 2

Generally, you should never check equality with floats (unless, potentially, you have the same object). Internally, it is represented with more precision, even if it isn't showing it to you by the time it outputs to the screen. This basic tenet holds true for computing in general.

There are a dozens of schemes for doing this, but here is a simple one, which should make sense:

SELECT * FROM table where value BETWEEN 4.599 AND 4.601