MySQL查询距离我最近的经纬点

SELECT  
  id, `name`,(  
    6378137 * ACOS (  
      COS ( RADIANS(60.000000) )  
      * COS( RADIANS( lat ) )  
      * COS( RADIANS( lng ) - RADIANS(70.000000) )  
      + SIN ( RADIANS(60.000000) )  
      * SIN( RADIANS( lat ) )  
    )
  ) AS distance  
FROM `T_ENTERPRISE`
ORDER BY distance 
LIMIT 0 , 20;  

 更多MySQL资源：http://www.developcls.com/qa/c88742c92da944e49f9aaa5d98adc3da.html