如何使用自动完成功能获取mysql数据库的纬度和经度 - How to get latitude and longitude on mysql database with autocomplete

How to get latitude and longitude on mysql database with autocomplete

I 有数据库

INSERT INTO `destination` (`destination_id`, `destination`, `latLng_lat`, `latLng_lng`)
VALUES
(3, 'Negara, Bali, Indonesia', -8.314990, 114.602493),
(4, 'Singapore', 1.352083, 103.819839),
(5, 'Jalan Negara, Mengwi, Bali, Indonesia', -8.606583, 115.194794),
(6, 'Bali, Indonesia', -8.409518, 115.188919),
(7, 'Jalan Raya Kuta, Kuta, Bali, Indonesia', -8.715054, 115.181091),
(8, 'Denpasar, Bali, Indonesia', -8.656290, 115.222099),
(9, 'Tabanan, Bali, Indonesia', -8.545040, 115.119957);

现在我想选择带有latLng_lat和latLng_lng的数据示例搜索方式"巴厘岛，印度尼西亚" latLng_lat=-8.4095178 and latLng_lng=115.188916

我想要显示结果

(3, 'Negara, Bali, Indonesia', -8.314990, 114.602493),
(5, 'Jalan Negara, Mengwi, Bali, Indonesia', -8.606583, 115.194794),
(6, 'Bali, Indonesia', -8.409518, 115.188919),
(7, 'Jalan Raya Kuta, Kuta, Bali, Indonesia', -8.715054, 115.181091),
(8, 'Denpasar, Bali, Indonesia', -8.656290, 115.222099),
(9, 'Tabanan, Bali, Indonesia', -8.545040, 115.119957);

您可以在查询字符串中使用 LIKE 子句而不是 =，以便它可以搜索从您搜索的字符串开始的行

类似这样的东西：latLng_lat像"%8"，latLng_lng像"%115"

参考链接： http://www.tutorialspoint.com/mysql/mysql-like-clause.htm

SELECT * FROM destination WHERE destination like '%Bali, Indonesia%'