mysql 根据经纬度安最近距离排序

SELECT title,address,(6371*acos(cos( radians(39.926588))*cos(radians(ln))*cos(radians(la)-radians(116.477051))+ sin(radians(39.926588))*sin(radians(ln)))) AS distance ,la ,ln from sh_publish  ORDER BY distance ASC

以上为已验证代码 

以下为参考资料：
MySQL:
例子：表名-sh_user  字段-latitude纬度   longitude经度         定位的经纬度：22.72114，114.2308
SELECT    
      s.*,(    
        6371 * acos (    
          cos ( radians(22.72114) )    
          * cos( radians( s.latitude ) )    
          * cos( radians( s.longitude ) - radians(114.2308) )    
          + sin ( radians(22.72114) )    
          * sin( radians( s.latitude ) )    
        )    
      ) AS distance    
    FROM sh_user u     
    ORDER BY distance   
    LIMIT 0 , 2000;

   LIMIT 0 , 2000----范围