SELECt id, ( 3959 * acos( cos( radians(37) ) * cos( radians( lat ) ) * cos(radians( lng ) - radians(-122) ) + sin( radians(37) ) * sin( radians( lat )) ) ) AS distance FROM markers HAVINg distance < 25 ORDER BY distance LIMIT0 , 20;
这是最好的查询
SELECt id, ( 3959 * acos( cos( radians(37) ) * cos( radians( lat ) ) * cos(radians( lng ) - radians(-122) ) + sin( radians(37) ) * sin( radians( lat )) ) ) AS distance FROM markers HAVINg distance < 25 ORDER BY distance LIMIT0 , 20;
这是最好的查询
名师互学网 版权所有 (c)2021-2022 ICP备案号：晋ICP备2021003244-6号
