SELECT *,
st_distance_sphere(point(longitude,latitude),point(116.3424590000,40.0497810000)) as juli
FROM gs_shop_coordinates ORDER BY juli ASC LIMIT 100
mysql 经纬度排序
最新推荐文章于 2023-09-14 15:56:03 发布
SELECT *,
st_distance_sphere(point(longitude,latitude),point(116.3424590000,40.0497810000)) as juli
FROM gs_shop_coordinates ORDER BY juli ASC LIMIT 100