mysql 根据经纬度 查询表中按经纬度位置最近排序

st_distance 为mysql5.6+版本中开始自带的经纬度计算函数,将直接返回 2个经纬度

st_distance (POINT (latitude1,lon

 select *,
     st_distance (POINT (latitude,longitude),POINT(#{latitude},#{longitude})) * 111195 AS distance
 from store_info 
 order by distance DESC  

gitude1),POINT(latitude2,longitude2)) * 111195