위/경도 좌표 간 거리 구하기

SET @LAT1 = 37.51033009658;

SET @LNG1 = 127.06107001752;

SET @LAT2 = 37.579617;

SET @LNG2 = 126.977041;

SELECT 

(6371*acos(cos(radians(@LAT1))*cos(radians( @LAT2))*cos(radians(@LNG2)

-radians(@LNG1))+sin(radians(@LAT1))*sin(radians( @LAT2))))

AS distance

참조 : http://www.php5.me/blog/mysql-%EC%9C%84%EB%8F%84-%EA%B2%BD%EB%8F%84-%ED%99%9C%EC%9A%A9%ED%95%9C-%EC%A2%8C%ED%91%9C%EA%B0%84%EC%9D%98-%EA%B1%B0%EB%A6%AC-%EA%B5%AC%ED%95%98%EB%8A%94%EB%B2%95-lng-lat-%EA%B0%80%EC%A7%80%EA%B3%A0/

검증 : https://www.nhc.noaa.gov/gccalc.shtml