SELECT *, AsText(location) as 原始坐标数据, (st_distance(location, point(116.397915,39.908946))*111) AS distance FROM oc_district HAVING distance<100 ORDER BY distance limit 100;
MySQL通过POIN数据类型查询指定范围内数据
原文：https://www.cnblogs.com/Soy-technology/p/10981124.html
