当前所处在的位置(113.858202 , 22.583819 ),须要查询我附近1000米内的小区,并安装由近到远的顺序排列 查询
SELECT
s.id,s.name,s.lng,s.lat,di
round ((st_distance (point (lng, lat),point(113.858202,22.583819) ) / 0.0111)*1000) AS distance
FROM
wlsq_base.lt spoi
HAVING distance<10
ORDER BY distance