指定经纬度与数据库多条经纬度进行距离计算

##121.308364,30.225778 示例对比的坐标

select * from broadcasts where location!='' and sqrt(  
    (  
     ((121.308364-longitude)*PI()*12656*cos(((30.225778+latitude)/2)*PI()/180)/180)  
     *  
     ((121.308364-longitude)*PI()*12656*cos (((30.225778+latitude)/2)*PI()/180)/180)  
    )  
    +  
    (  
     ((30.225778-latitude)*PI()*12656/180)  
     *  
     ((30.225778-latitude)*PI()*12656/180)  
    )  
)<20

 

本文转自 netcorner 博客园博客，原文链接： http://www.cnblogs.com/netcorner/p/6262357.html  ，如需转载请自行联系原作者