MySQL SELECT not working when data in table

Question

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.

Please, whenever possible post things like that as plain text formatted as code if necessary in the body of your question. External links like that are unreliable. — tadman
– tadman, Commented Apr 27, 2016 at 19:43

ScaisEdge · Accepted Answer · 2016-04-27 19:37:54Z

1

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

answered Apr 27, 2016 at 19:37

ScaisEdge

133k10 gold badges98 silver badges111 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

taricketts Over a year ago

This did work for all cases. What was weird though is that I created these as strings, and put them into the database casted as floats. Thanks for the help!

Ankit Pandey · Accepted Answer · 2016-04-27 20:01:59Z

0

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

Is it helping?

answered Apr 27, 2016 at 20:01

Ankit Pandey

11 bronze badge

Collectives™ on Stack Overflow

MySQL SELECT not working when data in table

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related