taricketts taricketts - 7 months ago 8
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
http://i.imgur.com/Uz1Rrb8.jpg
This query doesn't, even though the data is in there
http://i.imgur.com/SgXUC9o.jpg
Does anyone know why this is happening? The data type is a float, and a similar variable works.

Answer

could be the value stored is not exactly 0.7

try 

select * from learned_info where pos > 0.6;

or could be the value are not float