CODEWITHSUNDEEP
mysql
taricketts
taricketts

Reputation: 65

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 https://i.sstatic.net/TcVSZ.jpg This query doesn't, even though the data is in there https://i.sstatic.net/Guj0B.jpg Does anyone know why this is happening? The data type is a float, and a similar variable works.

Upvotes: 1

Views: 51

Answers (2)

Ankit Pandey
Ankit Pandey

Reputation: 1

SELECT * FROM table_name WHERE pos<=0.7 AND pos LIKE '%0.7';

Is it helping?

Upvotes: 0

ScaisEdge
ScaisEdge

Reputation: 133400

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

Upvotes: 1

Related Questions