Calculating distance using MySQL

"Calculating distance using MySQL" is a very useful blog post for everyone who works with geographical location data and MySQL. It shows a simple example of how to calculate the distance between two coordinates on a sphere (Earth in particular) within the MySQL itself. SELECT ST_Distance_Sphere( point(-87.6770458, 41.9631174), point(-73.9898293, 40.7628267) ); The above will return … Continue reading Calculating distance using MySQL