SELECT
id,
desa,
point
FROM
dyr_line
WHERE
point != ''
ORDER BY
GLength (LineStringFromWKB (LineString (GeomFromText(CONCAT('POINT(',(replace(point,',',' ')),')')) ,point (104.629239,28.770671)))) ASC
Mysql根据坐标字符串排序
最新推荐文章于 2024-08-12 09:24:46 发布