SQL statement to find locations within a X distance of another location (with lat / lng)

locations.sql

# https://gis.stackexchange.com/questions/31628/find-points-within-a-distance-using-mysql

SET @lat = 45.536264;
SET @long = -73.493025;

SELECT
  id, name, (
    6371 * acos (
      cos ( radians(@lat) )
      * cos( radians( lat ) )
      * cos( radians( lng ) - radians(@long) )
      + sin ( radians(@lat) )
      * sin( radians( lat ) )
    )
  ) AS distance
FROM locations
HAVING distance < 1.0 
ORDER BY distance