There is a MySQL database with the following table:
CREATE TABLE IF NOT EXISTS `my_table` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `name` text NOT NULL, `coords` point NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
The data is inserted into it like this:
INSERT INTO `my_table` VALUES (NULL, 'name1', POINT(50.456257,30.511237)), (NULL, 'name2', POINT(50.456230,30.511425)), (NULL, 'name3', POINT(50.456244,30.510902));
Now the actual task is to select from the table only those records that are located no farther than 5 meters from point A (the coordinates of the point are known).