Для начала создать хранимую процедуру вычисления расстояния по координатам:
delimiter $$
CREATE FUNCTION GetDistanceBetweenGeoLocations
(
lat1 float,
long1 float,
lat2 float,
long2 float
)
RETURNS float
DETERMINISTIC
BEGIN
DECLARE distance float;
DECLARE earth_radius float;
DECLARE axis float;
SET earth_radius = 6371.009;
SET axis = (SIN(RADIANS(lat2-lat1)/2) * SIN(RADIANS(lat2-lat1)/2) +
COS(RADIANS(lat1)) * COS(RADIANS(lat2)) *
SIN(RADIANS(long2-long1)/2) * SIN(RADIANS(long2-long1)/2));
SET distance = earth_radius * (2 * ATN2(SQRT(axis), SQRT(1-axis)));
RETURN ROUND(distance, 3);
END;
$$
После этого можно искать:
select * from points
where GetDistanceBetweenGeoLocations(n, 55.75272901, e, 37.60548887) <= 0.1
