imrealashu/sql_sp_distance_sphere.sql

Last active December 27, 2017 16:31

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/imrealashu/4cf8f4625768e7345bf23b2025c78f99.js"></script>
Save imrealashu/4cf8f4625768e7345bf23b2025c78f99 to your computer and use it in GitHub Desktop.

Download ZIP

Mysql raw query for spacial distance calculations.

Raw

sql_sp_distance_sphere.sql

	SELECT *,
	ST_DISTANCE_SPHERE(
	POINT(`table_name`.`lat`, `table_name`.`lng`),
	POINT('24.2449530', '85.4870880')) as `distance`
	FROM `table_name

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