What is the best way to calculate distance on earth with 2 coordinates in meters in MYSQL?

Question

I have got 2 sets google maps geo coordinates. Like 51.2, 6.1 and 50.3 and 5.5.

How do i calculate the distance between those 2 coordinates in meters with mysql?

I'm looking for the geo calculation, with earth radius and stuff. What is the best way to do this?

Are these coordinates lat/lon pairs, or coordinates on a map? How are they obtained? — fmark, Jun 21 '10 at 13:17

score 1 · Accepted Answer · edited May 23 '17 at 12:07

1

edited May 23 '17 at 12:07

Community

answered Jun 21 '10 at 08:57

Mark Baker

1 Answers1