taricketts taricketts - 1 year ago 68
SQL Question

MySQL SELECT not working when data in table

I am having an issue with a MySQL SELECT query.
Here is the data in the table
This query doesn't, even though the data is in there
Does anyone know why this is happening? The data type is a float, and a similar variable works.

Answer Source

could be the value stored is not exactly 0.7


select * from learned_info where pos > 0.6;

or could be the value are not float 
Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download