SELECT lat, lng, SQRT(POW(111.2 * ( lat - 31.8366060000), 2) + POW(111.2 * (118.5984990000 - lng) * COS(lat/ 57.3), 2)) AS distance
FROM rep_info where storeid !='BJ2'
ORDER BY distance LIMIT 100;
111.2 ??? 的由来
57.3 = 180/Math.PI() 可以理解
SELECT lat, lng, SQRT(POW(111.2 * ( lat - 31.8366060000), 2) + POW(111.2 * (118.5984990000 - lng) * COS(lat/ 57.3), 2)) AS distance
FROM rep_info where storeid !='BJ2'
ORDER BY distance LIMIT 100;
111.2 ??? 的由来
57.3 = 180/Math.PI() 可以理解
转载于:https://www.cnblogs.com/he0xff/p/6409610.html