MySQL根据经纬度排序

1.
SELECT *,
(st_distance(point(lng,lat),point(116.3424590000,40.0497810000))*111195/1000 ) as juli FROM table ORDER BY juli ASC 
2.
SELECT
	*, (
		2 * 6378.137 * ASIN(
			SQRT(
				POW(
					SIN(
						PI() * (111.86141967773438 - lng) / 360
					),
					2
				) + COS(PI() * 33.07078170776367 / 180) * COS(lat * PI() / 180) * POW(
					SIN(
						PI() * (33.07078170776367 - lat) / 360
					),
					2
				)
			)
		)
	) AS juli
FROM
	`area`
ORDER BY
	juli ASC