附近的店铺 mysql查询

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;