mysql经纬度定位

最新推荐文章于 2024-07-26 03:50:25 发布

未名胡

最新推荐文章于 2024-07-26 03:50:25 发布

阅读量864

点赞数

如有雷同，不喜勿喷

本文链接：https://blog.csdn.net/qq_30641447/article/details/53764856

版权

select * from sys_user_location where sqrt(  
               (  
               (('109.110296678266'-Longitude)*PI()*12656*cos((('21.4713962785714'+Latitude)/2)*PI()/180)/180)
               *  
                (('109.110296678266'-Longitude)*PI()*12656*cos ((('21.4713962785714'+Latitude)/2)*PI()/180)/180)  
                )  
                +  
                (  
                (('21.4713962785714'-Latitude)*PI()*12656/180) 
                *  
                 (('21.4713962785714'-Latitude)*PI()*12656/180)  
                )  
            )<50000

15分钟内的附件的人

select distinct(user_name),longitude,latitude,phone,begin_time from sys_user_location 
where sqrt(  
               (  
               (('109.110296678266'-Longitude)*PI()*12656*cos((('21.4713962785714'+Latitude)/2)*PI()/180)/180)
               *  
                (('109.110296678266'-Longitude)*PI()*12656*cos ((('21.4713962785714'+Latitude)/2)*PI()/180)/180)  
                )  
                +  
                (  
                (('21.4713962785714'-Latitude)*PI()*12656/180) 
                *  
                 (('21.4713962785714'-Latitude)*PI()*12656/180)  
                )  
            )<5000 AND now()-begin_time <900