Timeline for Find features within given coordinates and distance using MySQL
Current License: CC BY-SA 3.0
12 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Feb 29, 2020 at 2:36 | comment | added | Mapperz♦ | @AliAdil use Select Round (Number, 2) > w3schools.com/sqL/trymysql.asp?filename=trysql_func_mysql_round | |
| Feb 28, 2020 at 19:45 | comment | added | Ali Adil | Is't possible to reduce the distance result like in my case from 2.71250308462937983478013848070986568927764892578125 to 2.71 ? | |
| Feb 6, 2019 at 22:32 | comment | added | Vasilii Suricov | much better to replace it to 6371392.896 for searching by meters | |
| Feb 5, 2019 at 12:01 | comment | added | Amit Shah | Exactly what i wanted, but whats the query performance overload for thousands of records? and how about the accuracy? | |
| Nov 29, 2014 at 10:38 | comment | added | bluantinoo | Found: I had the lng variable empty! sorry! | |
| Nov 29, 2014 at 2:09 | comment | added | bluantinoo | I'm getting a syntax error in my select using this, "#1582 - Incorrect parameter count in the call to native function 'radians' what could it be? | |
| S Jan 6, 2014 at 22:25 | history | suggested | sachleen | CC BY-SA 3.0 |
the third number must be lat not lng. just a typo in copying over from google's page.
|
| Jan 6, 2014 at 22:22 | review | Suggested edits | |||
| S Jan 6, 2014 at 22:25 | |||||
| S Apr 14, 2013 at 18:46 | history | suggested | CommunityBot | CC BY-SA 3.0 |
Improved Readability
|
| Apr 14, 2013 at 18:39 | review | Suggested edits | |||
| S Apr 14, 2013 at 18:46 | |||||
| Jan 31, 2013 at 14:07 | vote | accept | shihab K | ||
| Aug 16, 2012 at 16:52 | history | answered | Mapperz♦ | CC BY-SA 3.0 |