如何允许全文搜索搜索结合?

时间:2022-12-04 20:11:40

When I do a search like: People in England, the full-text search engine ignores the all search and returns 0 results. I think It is because It separetes each word ("People", "in" and "England") and ignores the "in" word because It may return many results.

当我进行搜索时:英格兰人,全文搜索引擎忽略全部搜索并返回0结果。我认为这是因为它分隔每个单词(“人”,“在”和“英格兰”)并忽略“在”单词,因为它可能会返回许多结果。

I don't want the exact word ("People in England") but I'd like to find in the same text the words People, in and England.

我不想要确切的词(“英格兰人”),但我想在同一文本中找到人物,英语和英格兰。

1 个解决方案

#1


1  

You want "in" keyword (like OR, AND, ...)be considered a simple word in criteria, right?

您希望“in”关键字(如OR,AND,...)在标准中被视为一个简单的单词,对吧?

You must configure stopword for your fulltext query, here is as link about it:

您必须为全文查询配置停用词,这里是关于它的链接:

https://dba.stackexchange.com/questions/44032/searching-for-keywords-in-fulltext-indexes-using-the-contains-function

#1


1  

You want "in" keyword (like OR, AND, ...)be considered a simple word in criteria, right?

您希望“in”关键字(如OR,AND,...)在标准中被视为一个简单的单词,对吧?

You must configure stopword for your fulltext query, here is as link about it:

您必须为全文查询配置停用词,这里是关于它的链接:

https://dba.stackexchange.com/questions/44032/searching-for-keywords-in-fulltext-indexes-using-the-contains-function