Find nearest latitude/longitude with an SQL query

by 
SELECT latitude, longitude, SQRT(
    POW(69.1 * (latitude - [startlat]), 2) +
    POW(69.1 * ([startlng] - longitude) * COS(latitude / 57.3), 2)) AS distance
FROM TableName HAVING distance < 25 ORDER BY distance;

where [starlat] and [startlng] is the position where to start measuring the distance.

More Related Contents:

  1. Use MySQL spatial extensions to select points inside circle
  2. Whats the fastest way to lookup big tables for points within radius MySQL (latitude longitude)
  3. how to delete data from table A besides the customer service and director data in table B?
  4. Get records with max value for each group of grouped SQL results
  5. How to populate a table with a range of dates?
  6. MYSQL OR vs IN performance
  7. SELECTING with multiple WHERE conditions on same column
  8. ERROR 1452: Cannot add or update a child row: a foreign key constraint fails
  9. Getting “Lock wait timeout exceeded; try restarting transaction” even though I’m not using a transaction
  10. Cannot delete or update a parent row: a foreign key constraint fails
  11. Using union and order by clause in mysql
  12. Using an Alias in SQL Calculations
  13. How do I select an entire row which has the largest ID in the table?
  14. MySQL/MariaDB – order by inside subquery
  15. Can MySQL replace multiple characters?
  16. OUTPUT Clause in MySQL
  17. Using ORDER BY and GROUP BY together
  18. Sorting by date & time in descending order?
  19. Case statement in MySQL
  20. MySQL Pivot Table Column Data as Rows
  21. updating columns with a sequence number mysql
  22. MySQL, Concatenate two columns
  23. Select a column with a keyword name
  24. ERROR 1148: The used command is not allowed with this MySQL version
  25. Use Composite Primary Key as Foreign Key
  26. How to select data where a field has a min value in MySQL?
  27. How to SELECT by MAX(date)?
  28. get a recursive parent list
  29. Optimistic locking in MySQL
  30. Insert and set value with max()+1 problems

Leave a Comment