select *,round(6378.138*2*asin(sqrt(pow(sin( ({$x1}*pi()/180-ypoint*pi()/180)/2),2)+cos({$x1}*pi()/180)*cos(ypoint*pi()/180)* pow(sin( ({$y1}*pi()/180-xpoint*pi()/180)/2),2)))*1000) as distance from…….order by distance asc
其中,$x1为当前纬度,$y1为当前经度,xpoint为目标经度,ypoint为目标纬度;
这两个结合起来即可查询出最终排序。