sumon-sarker/mysql_search_by_lat_lang

Created March 12, 2018 07:26

Star () You must be signed in to star a gist
Fork () You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/sumon-sarker/5ef9102d5895d94fa2f4823d999c0454.js"></script>
Save sumon-sarker/5ef9102d5895d94fa2f4823d999c0454 to your computer and use it in GitHub Desktop.

Download ZIP

Raw

mysql_search_by_lat_lang

SELECT *, (3959 * acos(cos(radians('40.7142')) * cos(radians(latitudeColName)) * cos( radians(longitudeColName) - radians('-74.0064')) + sin(radians('40.7142')) * sin(radians(latitudeColName)))) AS distance FROM myTable HAVING distance < 15 ORDER BY distance LIMIT 0 , 10

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment