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