We have answer of your question!

100% solved queries, no empty question

Question: SQL statement returning not result [duplicate]


0

Advertisement


This question already has an answer here:

Question author Stephen | Source

Answer


1


Advertisement


It's not a good idea to compare floating point numbers with equality. because floating point numbers don't always store the exact value that you think it stores.

Secondly, if you are storing geographic data, you really should be doing a distance look up. Fetch items with in a distance x meters from a particular location. That's because if you two two GPS readings at the very same spot two minutes apart the readings are likely to be different.

Last but not least you should upgrade to mysql 5.7 and use the spatial data types and functions.

Answer author E4c5

Advertisement


Tickanswer.com is providing the only single recommended solution of the question SQL statement returning not result [duplicate] under the categories i.e mysql , codeigniter , activerecord , . Our team of experts filter the best solution for you.

Related Search Queries:

You may also add your answer!