mpratt

SELECT id, nombre, (6371 * ACOS( 
                                SIN(RADIANS(lat)) * SIN(RADIANS(4.6665578)) 
                                + COS(RADIANS(lng - -74.0524521)) * COS(RADIANS(lat)) 
                                * COS(RADIANS(4.6665578))
                                )
                   ) AS distance
FROM direcciones
HAVING distance < 1 /* 1 KM  a la redonda */
ORDER BY distance ASC