sql根据两点经纬度计算距离
<pre><code>substring_index(lng_lat,',',-1) -- sql切割字符串
SELECT
*,
(
6371 * acos(
cos( radians(&quot;.$lat1.&quot;) )
*
cos( radians(lat) )
*
cos( radians(&quot;.$lng.&quot;) - radians(lng) )
+
sin( radians(&quot;.$lat.&quot;) )
*
sin(radians(lat))
)
)*1000 AS distance
FROM
table
WHERE
1=1
ORDER BY
distance
LIMIT 1,10</code></pre>