SELECT
round ( ( st_distance(point (Y坐标,X坐标), point(传入的Y坐标,传入的X坐标))/ 0.0111),3) AS distance
FROM
查询的表名
HAVING distance <= 附近的距离
ORDER BY distance //排序
SELECT
round ( ( st_distance(point (Y坐标,X坐标), point(传入的Y坐标,传入的X坐标))/ 0.0111),3) AS distance
FROM
查询的表名
HAVING distance <= 附近的距离
ORDER BY distance //排序