MYSQL如何判断给定坐标点是否在已存储的经纬度边界区域内

• 字段名不匹配：你现有查询使用的south_lat、north_lat、south_lng、north_lng并非表中实际存在的字段，你的区域表存储边界坐标的字段为north_east_lat（区域东北角纬度）、south_west_lat（区域西南角纬度）、north_east_long（区域东北角经度）、south_west_long（区域西南角经度）。
• 坐标判断逻辑需符合经纬度特性：常规WGS84等坐标系下，纬度数值越高代表位置越靠北，因此区域东北角的纬度必然大于西南角纬度；东经范围内经度数值越高代表位置越靠东，区域东北角经度大于西南角经度。

SELECT * FROM test 
WHERE 
  36.206006 BETWEEN south_west_lat AND north_east_lat
  AND 43.995311 BETWEEN south_west_long AND north_east_long

如果你的业务涉及跨国际日期变更线的区域存储，可使用以下逻辑兼容：

SELECT * FROM test 
WHERE 
  36.206006 BETWEEN south_west_lat AND north_east_lat
  AND (
    (south_west_long <= north_east_long AND 43.995311 BETWEEN south_west_long AND north_east_long)
    OR (south_west_long > north_east_long AND (43.995311 >= south_west_long OR 43.995311 <= north_east_long))
  )

内容的提问来源于stack exchange，提问作者Mohammed Riyadh