##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 ,如需转载请自行联系原作者