query.sql

SET 
  @orig_latitude = 32.867073, 
  @orig_longitude = -96.769410, 
  @radius = 10
;

SELECT *
FROM (
  SELECT 
    `geonameid`, `name`,
    3956 * ACOS(COS(RADIANS(@orig_latitude)) * COS(RADIANS(`latitude`)) * COS(RADIANS(@orig_longitude) - RADIANS(`longitude`)) + SIN(RADIANS(@orig_latitude)) * SIN(RADIANS(`latitude`))) AS `distance`
  FROM `geoname`
  WHERE
    `latitude` 
      BETWEEN @orig_latitude - (@radius / 69) 
      AND @orig_latitude + (@radius / 69)
    AND `longitude` 
      BETWEEN @orig_longitude - (@radius / (69 * COS(RADIANS(@orig_latitude)))) 
      AND @orig_longitude + (@radius / (69* COS(RADIANS(@orig_latitude))))
) r
WHERE `distance` < @radius
ORDER BY `distance` ASC
;

Thanks mate.

Thank you very much, this is just took milliseconds to get the data.