数据库

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

云博小周宇1 Min Read 
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资源：https://www.shangmayuan.com/a/0aac1c68952e46b781a43f51.html