sql测距离

SELECT store_name,lng,lat, round ((st_distance (point (lng, lat),point(108.93774,34.343803) ) / 0.0111)*1000) AS distance FROM pay_store_info HAVING distance<1000 ORDER BY distance

select s.id,s.store_name,s.lat,s.lng,
(st_distance(point(s.lng,s.lat),point(108.93774,34.343803))*111195) as distance 
from pay_store_info as  s
having distance <= 20000 
order by distance

转载于:https://my.oschina.net/u/3371661/blog/3099975