위도: 37.6184471, 경도: 126.3825912

SELECT

    (6371*acos(cos(radians(userLatitude))*cos(radians(cafeLatitude))*cos(radians(cafeHardness)

    -radians(userHardness))+sin(radians(userLatitude))*sin(radians(cafeLatitude))))

    AS distance

FROM Cafe,User

-- HAVING distance <= (이 값을 지정하면 특정거리 이하만 출력하게 할 수 있음)

ORDER BY distance;

SELECT ( 6371 * ACOS( COS( RADIANS( 37.4525425 ) ) * COS( RADIANS( 37.1485415 ) ) * COS( RADIANS( 37.9874521 ) - RADIANS( 126.54857458 ) ) + SIN( RADIANS( 126.7845121 ) ) * SIN( RADIANS( 126.3652512 ) ) ) ) AS `distance`
FROM `g5_write_hotline`
ORDER BY `distance`
LIMIT 0 , 30