Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT *, 3956 * 2 * ASIN(SQRT( POWER(SIN((" & Lat & " - abs(dest.lat)) * pi()/180 / 2),2) + COS(" & Lat & * pi()/180 ) * COS(abs(dest.lat) * pi()/180) * POWER(SIN((" & Lng & - dest.lng) * pi()/180 / 2), 2) )) AS distance
- FROM data__metar_stations AS dest
- ORDER BY distance
- LIMIT 1;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement