Guest User

Untitled

a guest
Jan 20th, 2018
96
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.28 KB | None | 0 0
  1. SELECT
  2. zipcode
  3. (
  4. 3959 * acos(
  5. cos(radians($LattitudeVar)) * cos(radians(latitude)) * cos(
  6. radians(longitude) - radians($longitudeVar)
  7. ) + sin(radians($LattitudeVar)) * sin(radians(latitude))
  8. )
  9. ) AS distance
  10. FROM
  11. zipcodedata
  12. HAVING
  13. distance <= 5
  14. ORDER BY
  15. distance
Add Comment
Please, Sign In to add comment