mysql 根据经纬度安最近距离排序
SELECT title,address,(6371*acos(cos( radians(39.926588))*cos(radians(ln))*cos(radians(la)-radians(116.477051))+ sin(radians(39.926588))*sin(radians(ln)))) AS distance ,la ,ln from sh_publish ORDER B...
原创
2020-01-07 17:28:20 ·
405 阅读 ·
0 评论