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
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.