SELECT
lon,lat,id,name,
ST_Distance
(
point ( lon, lat ),
point ( 106.6890580000000, 26.60426400000000 )
)*111195 AS jl
FROM
rl_pollution_source_vocabulary
HAVING jl<=1000
如果觉得《mysql根据经纬度查询距离在1000米范围内的数据》对你有帮助,请点赞、收藏,并留下你的观点哦!
时间:2021-04-02 09:28:38
SELECT
lon,lat,id,name,
ST_Distance
(
point ( lon, lat ),
point ( 106.6890580000000, 26.60426400000000 )
)*111195 AS jl
FROM
rl_pollution_source_vocabulary
HAVING jl<=1000
如果觉得《mysql根据经纬度查询距离在1000米范围内的数据》对你有帮助,请点赞、收藏,并留下你的观点哦!