Declare @lat float,@lon float,@multiplier float,@distance float
Set @lat = -3152
Set @lon = -6852
Set @multiplier = 112.12
Set @distance = 10
SELECT *,
(SQRT(POWER((lat - @lat), 2)) + POWER((lng - @lon), 2)) * @multiplier) AS distance
FROM routes
WHERE POWER((lat - @lat), 2)) + POWER((lng - @lon), 2)) < POW((@distance / @multiplier), 2)
ORDER BY distance ASC
mySQL syntax
Posted - 12/04/2012 : 20:30:34
