Latitude/Longitude

geo.md

Calculate distance, bearing and more between Latitude/Longitude points http://www.movable-type.co.uk/scripts/latlong.html

-- Spherical Law of Cosines: calculate distance to other points

SET @lat = 51.053283, @lon = 3.720359;
SELECT *
FROM (
       SELECT
         *,
         (
           (
             (
               acos(
                   sin((@lat * pi() / 180)) * sin((`latitude` * pi() / 180)) +
                   cos((@lat * pi() / 180)) * cos((`latitude` * pi() / 180)) * cos(((@lon - `longitude`) * pi() / 180))
               )
             ) * 180 / pi()
           ) * 60 * 1.1515 * 1.609344
         ) AS distance
       FROM `cms_items_dealers`) myTable
ORDER BY distance ASC