mysql - 数据检索取决于经度和纬度之间的公里数

Question

我在数据库中保存了以下内容

+----+-----------+------------+------+---------+------------+------------+------------+------------+
| id | post_code | type       | data | type_id | longitude  | latitude   | created_at | updated_at |
+----+-----------+------------+------+---------+------------+------------+------------+------------+
|  1 | 52111     | properties | NULL |       3 | 39.3260685 | -4.8379791 | NULL       | NULL       |
|  2 | 51111     | properties | NULL |       3 | 39.3260685 | -4.8379791 | NULL       | NULL       |
|  3 | 59111     | properties | NULL |       3 | 39.3260685 | -4.8379791 | NULL       | NULL       |
|  4 | 59111     | properties | NULL |       3 | 39.3260685 | -4.8379791 | NULL       | NULL       |
|  5 | 59111     | properties | NULL |       3 | 39.3260685 | -4.8379791 | NULL       | NULL       |
|  6 | 50111     | properties | NULL |       3 | 39.3260685 | -4.8379791 | NULL       | NULL       |
|  7 | 51121     | properties | NULL |       3 | 39.3260685 | -4.8379791 | NULL       | NULL       |
|  8 | 51121     | properties | NULL |       3 | 39.3260685 | -4.8379791 | NULL       | NULL       |
|  9 | 51121     | properties | NULL |       3 | 39.3260685 | -4.8379791 | NULL       | NULL       |
| 10 | 51121     | properties | NULL |       3 | 39.3260685 | -4.8379791 | NULL       | NULL       |
| 11 | 51121     | properties | NULL |       3 | 39.3260685 | -4.8379791 | NULL       | NULL       |
| 12 | 51121     | properties | NULL |       3 | 39.3260685 | -4.8379791 | NULL       | NULL       |
| 13 | 51121     | properties | NULL |       3 | 39.3260685 | -4.8379791 | NULL       | NULL       |
| 14 | 51121     | properties | NULL |       3 | 39.3260685 | -4.8379791 | NULL       | NULL       |
+----+-----------+------------+------+---------+------------+------------+------------+------------+

我想接收基于 post_code 和我应该根据纬度和经度计算的公里范围的数据

在这种情况下如何继续计算范围？这样的事情有公式吗？我想创建一个范围为 2 公里的位置，并在该范围内显示我的 post_codes

标签： mysqllaravel