MySql根据经纬度查询任意距离范围内数据

2021-5-07 13:34

1,530

0 字

几秒读完

#当前位置经纬度 经度：117.215637 纬度：39.1373367
#表中经纬度字段 经度：longitude 纬度：latitude
select * from(
SELECT id,longitude,latitude,
ROUND(6378.138*2*ASIN(SQRT(POW(SIN((39.1373367*PI()/180-latitude*PI()/180)/2),2)+COS(39.1373367*PI()/180)*COS(latitude*PI()/180)*POW(SIN((117.215637*PI()/180-longitude*PI()/180)/2),2)))*1000) AS juli
FROM table_name) as tmp_table_name
where juli < 1000
order by juli