Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT libname, city, 2 * 3961 * ASIN(SQRT((SIN(RADIANS((lat - 40.113799) / 2))) ^ 2 + COS(RADIANS(40.113799)) * COS(RADIANS(lat)) * (SIN(RADIANS((lon - -88.225202) / 2))) ^ 2)) as distance
- FROM Charters
- ORDER BY distance ASC /* in miles */
- LIMIT 50
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement