<p><span style="color: #404040; font-family: 굴림;">이제 기준점 (127.0000000, 37.0000000)에서 DB에 저장된 지점의 거리를 계산하는 Query&nbsp;</span><br style="color: #404040; font-family: 굴림;" /><br style="color: #404040; font-family: 굴림;" /><span style="color: #404040; font-family: 굴림;">SELECT rowid, withgo_dest_address, ( 6371 * acos( cos( radians(37) ) * cos( radians( withgo_dest_lat ) ) * cos( radians( withgo_dest_long ) - radians(127) ) + sin( radians(37) ) * sin( radians( withgo_dest_lat ) ) ) ) AS distance FROM main_withgo_table HAVING distance &lt; 500 ORDER BY distance LIMIT 0 , 5;&nbsp;</span><br style="color: #404040; font-family: 굴림;" /><br style="color: #404040; font-family: 굴림;" /><span style="color: #404040; font-family: 굴림;">* &lt; 500 : 반경 km&nbsp;</span><br style="color: #404040; font-family: 굴림;" /><span style="color: #404040; font-family: 굴림;">* LIMIT 0, 5 : 가까운 순서로 5개</span></p>