SELECT id, ( 6371 * acos( cos( radians(31.296452) ) * cos( radians( `latitude` ) ) * cos( radians( `longitude` ) - radians(121.428709) ) + sin( radians(31.296452) ) * sin( radians( `latitude` ) ) ) ) AS distance FROM `supply_warehouse` HAVING distance < 3;
6379 表示公里