MySQL calculates the distance between two points longitude and latitude "turn"

The formula is as follows, unit meters:

1th latitude and Longitude: lng1 LAT1

2nd latitude and Longitude: lng2 lat2

Round (6378.138*2*asin (sqrt (POW (LAT1*PI ()/180-lat2*pi ()/180)/2), 2) +cos (Lat1*pi ()/180) *cos (LAT2*PI ()/180) * Pow (Sin ((Lng1*pi ()/180-lng2*pi ()/180)/2), 2)) *1000)

For example:

SELECT

STORE_ID,

Lng

Lat

ROUND (6378.138*2*asin (SQRT (POW (SIN (22.299439*pi ()/180-lat*pi ()/180)/2), 2) +cos (22.299439*pi ( )/180) *cos (Lat*pi ()/180) *pow (SIN ((114.173881*pi ()/180-lng*pi ()/180)/2), 2))) *1000) as Juli
From

Store_info
ORDER by

Juli DESC

The resources are as follows:

Http://blog.sina.com.cn/s/blog_8da982ac0101jeh5.html

MySQL calculates the distance between two points longitude and latitude "turn"