Mysql根据经纬度按距离排序 

经度，纬度（116.3424590000,40.0497810000）
SELECT *,(st_distance(point(longitude,latitude),point(116.3424590000,40.0497810000))*111195/1000 ) as juli FROM farm_land ORDER BY juli ASC

 

posted @ 2022-10-03 19:04  ki1616  阅读(186)  评论(0)  编辑  收藏  举报