mysql全文从一个表单输入多个单词？

发布于 2024-11-18 14:29:27 字数 203 浏览 4 评论 0原文

我听过很多类似的讨论，但我还没有看到直接的解决方案。

SELECT * FROM patient_db WHERE 
       MATCH ( Name, id_number ) AGAINST ('%$term%' IN BOOLEAN MODE);

我需要在“%$term%”周围做一些简单的事情来启用多单词搜索吗？

原文

I've heared alot of similar discussion but I havent seen a direct solution.

SELECT * FROM patient_db WHERE 
       MATCH ( Name, id_number ) AGAINST ('%$term%' IN BOOLEAN MODE);

Isn't there something simple around my '%$term%' I need to do to enable multiple-word searching?

分享到QQ

分享到微博

如果你对这篇内容有疑问，欢迎到本站社区发帖提问参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。

发布评论

需要登录才能够评论，你可以免费注册一个本站的账号。

皇甫轩 2024-11-25 14:29:27

不幸的是，没有办法在 MySQL 全文查询中直接说“我想要这些 n 个单词之一”。您唯一真正的选择

SELECT * FROM patient_db WHERE 
       MATCH ( Name, id_number ) AGAINST ('%$term%' IN BOOLEAN MODE)
       OR MATCH ( Name, id_number ) AGAINST ('%$term2%' IN BOOLEAN MODE)
       OR MATCH ( Name, id_number ) AGAINST ('%$term3%' IN BOOLEAN MODE)
       ;

只是好奇，但为什么要在名为 id_number 的列中搜索文本？

Unfortunately, there is no way to directly say, "I want one of these n words" in a MySQL fulltext query. Your only real option is

SELECT * FROM patient_db WHERE 
       MATCH ( Name, id_number ) AGAINST ('%$term%' IN BOOLEAN MODE)
       OR MATCH ( Name, id_number ) AGAINST ('%$term2%' IN BOOLEAN MODE)
       OR MATCH ( Name, id_number ) AGAINST ('%$term3%' IN BOOLEAN MODE)
       ;

Just curious, but why are you searching a column named id_number for text?

回复收藏 0 原文

~没有更多了~