Mysql takes the specified latitude and longitude to calculate the distance from the database.

The formula is as follows, Unit meter: 1th Latitude: lng1 lat1 2nd latitude and Longitude: lng2 lat2round (6378.138*2*asin (Pow ((sqrt () LAT1*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 (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 Julifrom store_ Info has juli > 500ORDER by Juli Desclimit 100

Mysql takes the specified latitude and longitude to calculate the distance from the database.