ST_Distance_Sphere

计算地球上两点之间的球面距离，单位为“米”。 输入的参数为 X 处的经度、X 处的纬度、Y 处的经度、Y 处的纬度。

语法

DOUBLE ST_Distance_Sphere(DOUBLE x_lng, DOUBLE x_lat, DOUBLE y_lng, DOUBLE x_lat)

示例

MySQL > select st_distance_sphere(116.35620117, 39.939093, 116.4274406433, 39.9020987219);
+----------------------------------------------------------------------------+
| st_distance_sphere(116.35620117, 39.939093, 116.4274406433, 39.9020987219) |
+----------------------------------------------------------------------------+
|                                                         7336.9135549995917 |
+----------------------------------------------------------------------------+

关键词

ST_DISTANCE_SPHERE,ST,DISTANCE,SPHERE