Determine if one coordinate is in radius of another

by

This post shows how to do this in SQL Server.

And here is how to do it in MySQL:

SELECT ((ACOS(SIN($lat * PI() / 180) * SIN(lat * PI() / 180) + 
         COS($lat * PI() / 180) * COS(lat * PI() / 180) * COS(($lon - lon) * 
         PI() / 180)) * 180 / PI()) * 60 * 1.1515) AS distance 
FROM members 
HAVING distance<='10' ORDER BY distance ASC

More Related Contents:

  1. What datatype to use when storing latitude and longitude data in SQL databases? [duplicate]
  2. SQL where clause odd behavior [closed]
  3. SQL Server Exec issue [closed]
  4. SQL Query output in VBA is different than in SQL Oracle
  5. Count(*) vs Count(1) – SQL Server
  6. How do I escape a single quote in SQL Server?
  7. Selecting data from two different servers in SQL Server
  8. PostgreSQL: running count of rows for a query ‘by minute’
  9. SQL SELECT WHERE field contains words
  10. How to use the ‘as’ keyword to alias a table in Oracle?
  11. How to delete duplicate entries?
  12. How to rewrite IS DISTINCT FROM and IS NOT DISTINCT FROM in SQL Server 20008R2?
  13. Date Difference between consecutive rows
  14. SQL Server: Howto get foreign key reference from information_schema?
  15. How do you import a large MS SQL .sql file?
  16. Difference between Subquery and Correlated Subquery
  17. Database EAV Pros/Cons and Alternatives
  18. Can a stored procedure/function return a table?
  19. sqlplus statement from command line
  20. Naming of ID columns in database tables
  21. Conditional logic in PostDeployment.sql script using SQLCMD
  22. How to rename something in SQL Server that has square brackets in the name?
  23. SQL Server 2008 paging methods?
  24. How do I ALTER a PostgreSQL table and make a column unique?
  25. Issue when comparing result of to_char(myDate, ‘DAY’) to a string
  26. how to separate string into different columns?
  27. How to compare dates in SQL Server
  28. SQL difference between rows
  29. SQL Server updating a time stamp column
  30. What is difference between foreign key and reference key?

Leave a Comment