Mysql 根据经纬度计算距离

方式1：st_distance_sphere

st_distance_sphere函数返回以米为单位

SELECT
	*,st_distance_sphere (
	point ( longitudes, latitudes ),
	point ( 113.264435, 23.129163 )) AS juli 
FROM
	zxh_distance 
ORDER BY
	juli ASC;

方式2：st_distance

st_distance返回的度
st_distance 计算的结果单位是度，需要乘111195（地球半径6371000*PI/180）是将值转化为米。

SELECT
	*,st_distance (
	point ( longitudes, latitudes ),
	point ( 113.264435, 23.129163 )) AS juli 
FROM
	zxh_distance 
ORDER BY
	juli ASC;

方式3 直接计算

SELECT
	*,ROUND(
		6378.138 * 2 * ASIN(
			SQRT(
			POW( SIN(( 23.129163 * PI()/ 180-latitudes * PI()/ 180 )/ 2 ), 2 )+ COS( 23.129163 * PI()/ 180 )* COS( latitudes * PI()/ 180 )* POW( SIN(( 113.264435 * PI()/ 180-longitudes * PI()/ 180 )/ 2 ), 2 )))* 1000 
	) AS juli 
FROM
	zxh_distance 
ORDER BY
	juli ASC

原文链接：https://blog.csdn.net/qq_39632561/article/details/119949634

st_distance_sphere原文:https://dev.mysql.com/doc/refman/8.0/en/spatial-convenience-functions.html

st_distance原文：https://dev.mysql.com/doc/refman/8.0/en/spatial-relation-functions-object-shapes.html#function_st-distance