mysql 根据经纬度 查询表中按经纬度位置最近排序
st_distance 为mysql5.6+版本中开始自带的经纬度计算函数,将直接返回 2个经纬度
st_distance (POINT (latitude1,longitude1),POINT(latitude2,longitude2)) * 111195
select *,
st_distance (POINT (latitude,longitude),POINT(#{latitude},#{longitude})) * 111195 AS distance
from store_info
order by distance DESC