sql 经纬度范围检索(谷歌方案)

SELECT  
  id, (  
    6371 * acos (  
      cos ( radians(78.3232) )  
      * cos( radians( 数据库纬度字段) )  
      * cos( radians( 数据库经度字段) - radians(65.3234) )  
      + sin ( radians(78.3232) )  
      * sin( radians( latitude ) )  
    )  
  ) AS distance  ,
    name
FROM tb_hotel  
HAVING distance < 0.4
ORDER BY distance  
LIMIT 0 , 20;