SQL Server 2008 FullTextSearch名称中的单个字符缺少结果 [英] SQL Server 2008 FullTextSearch Single Character in Name Missing from Results

问题描述

我在SQL Server 2008中有一个全文索引列，它有以下几行：

W Smithers，Wilda Smithers，W2 Smithers

当我运行以下查询时，我只能找回Wilda Smithers和W2 Smithers。

  SELECT FT_TBL.full_name作为结果
 FROM dbo.ft_table AS FT_TBL WITH（NOLOCK）
 INNER JOIN CONTAINSTABLE（ft_table，full_name，'（w * ANDsmither *）'，12）AS KEY_TBL 
 ON FT_TBL.ft_key_id = KEY_TBL。[KEY] 
 ORDER BY KEY_TBL.RANK desc 
  

关于如何调整这个的建议，所以W Smithers也在我的结果集中？

解决方案

W可能是一个停止词。尝试从停止列表中删除它。

检查此链接以了解它是如何完成的：为全文搜索配置和管理停用词和停止列表

编辑

尝试重新创建金融时​​报指数，但这次根本没有指定任何止损列表。

I have a full text indexed column in SQL Server 2008 which has the following rows:

W Smithers, Wilda Smithers, W2 Smithers

When I run the following query I only get back Wilda Smithers and W2 Smithers.

SELECT  FT_TBL.full_name as results
FROM dbo.ft_table AS FT_TBL WITH (NOLOCK) 
INNER JOIN CONTAINSTABLE (ft_table , full_name, '("w*" AND "smither*")',12) AS KEY_TBL 
ON FT_TBL.ft_key_id = KEY_TBL.[KEY]
ORDER BY KEY_TBL.RANK desc

Any suggestions on how to tweak this so W Smithers is also in my result set?

解决方案

The W probably is a stop word. Try to remove it from the stoplist.

Check this link to see how it is done: Configure and Manage Stopwords and Stoplists for Full-Text Search

EDIT

Try to recreate the FT index, but this time do not specify any stop list at all.

这篇关于SQL Server 2008 FullTextSearch名称中的单个字符缺少结果的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！