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

sql代码

#当前位置经纬度 经度：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