摘要：SET @pt2 = ST_GeomFromText('POINT(116.405289 39.904987)'); SELECT *,ST_Distance_Sphere(ST_GeomFromText(CONCAT('POINT(',lng,' ',lat,')')), @pt2) as aa FROM pb_area WHERE ST_Distance_Sphere(ST_Geo... 阅读全文