%20*%20(%20%22%20.)
data['longitude'] . "- map_longitude ) / 360 ), 2 ) + COS( PI( ) * " . ![data['latitude'] . " / 180 ) * COS( map_latitude * PI( ) / 180 ) * POW( SIN( PI( ) * ( " .](https://math.jianshu.com/math?formula=data%5B'latitude'%5D%20.%20%22%20%2F%20180%20)%20*%20COS(%20map_latitude%20*%20PI(%20)%20%2F%20180%20)%20*%20POW(%20SIN(%20PI(%20)%20*%20(%20%22%20.)
data['latitude'] . "- map_latitude ) / 360 ), 2 )))*1000) AS distance FROM shop ORDER BY distance ASC");
%20*%201.5%20%2F%206378.137%3B%20%2F%2F%E9%87%8C%E9%9D%A2%E7%9A%84%201%20%E5%B0%B1%E4%BB%A3%E8%A1%A8%E6%90%9C%E7%B4%A2%201km%20%E4%B9%8B%E5%86%85%EF%BC%8C%E5%8D%95%E4%BD%8Dkm6372.797)
lngR = 
latitude * pi() / 180);
latitude + 
minLat = 
range; //最小緯度
longitude + 
minLng = 
lngR; //最小經(jīng)度
