Mysql根据坐标字符串排序

来源:互联网 发布:5s4g网络怎么设置 编辑:程序博客网 时间:2024/05/29 07:30
SELECTid,desa,pointFROMdyr_lineWHEREpoint != ''ORDER BYGLength (LineStringFromWKB (LineString (GeomFromText(CONCAT('POINT(',(replace(point,',',' ')),')')) ,point (104.629239,28.770671)))) ASC

原创粉丝点击