SQL Server全文搜索不适用于我 [英] SQL Server Full Text Search not working for me

问题描述

我在SQL Server中使用全文搜索时遇到问题. 我的查询:

I have problem with Full Text Search in SQL Server. My query:

Select [Name] From [POI] Where Contains([Name],  N'"bank of*"');

查询不返回任何行. 但是表有几行包含"...的行" 当我删除"of"一词时，一切正常. 请帮助解决此问题.

Query returns no rows. But table has several rows that contains "bank of ..." When I delete the word "of" everything works. Please help to solve this problem.

推荐答案

如其他问题所述

As described in this other question Dropping noise words in SQL Server 2005 full text indexing, noise words are not included in the indexing. "of" is a noise word, which would explain the behavior you're seeing.

另请参阅:

配置和管理全文搜索的停用词和停用列表

SQL Server中的噪声/停止词

SQL Server:没有由噪声引起的搜索结果字

其中包含建议

ALTER FULLTEXT INDEX ON table
   SET STOPLIST OFF;

这篇关于SQL Server全文搜索不适用于我的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！