SQL Server 2005全文搜索 - 我可以搜索正斜杠字符吗？ [英] SQL Server 2005 Full-Text Search - can I search for forward-slash characters?

问题描述

我尝试使用SQL Server 2005的全文搜索功能在索引列中查找单个正斜杠字符，但没有成功。

任何人都可以告诉我如果这是可能的话？例子：

在我的 CentralSearchCache 表中， SearchData 列包含一行文本This / string / contains / forward / slashes。

这个查询：

  SELECT * FROM FREETEXTTABLE（CentralSearchCache，SearchData，'forward / slashes'）
  

返回数据，而这个查询：

  SELECT * FROM FREETEXTTABLE（CentralSearchCache，SearchData，'/'）
  

不会返回任何内容。有没有办法找到包含一个或多个正斜杠字符的行？

>解决方案

最有可能不是。完整的TEXT搜索是针对TEXT的。不可能搜索文本分隔符，甚至是杀词（比如in，on等）的特定词语，这些词语经常发生，并且每一个非平凡的文本都会有。）

是否过滤出/是一个问题，我会以某种方式打赌它。

I'm trying to use SQL Server 2005's Full-Text Search to find single forward-slash characters within my indexed column, without success.

Can anyone tell me if this is possible at all? Example:

In my CentralSearchCache table, the SearchData column contains a row with the text "This/string/contains/forward/slashes".

This query:

SELECT * FROM FREETEXTTABLE(CentralSearchCache, SearchData, 'forward/slashes')

returns data, whereas this query:

SELECT * FROM FREETEXTTABLE(CentralSearchCache, SearchData, '/')

returns nothing. Is there any way of finding rows that contain one or more forward-slash characters?

Many thanks.

解决方案

Most likely NOT. Full TEXT search is for TEXT. It is not possible to search for text delimiters and even specific words that are "kill words" (like "in", "on" etc. - that are happening way too often and that every non-trivial text will have anyway).

Whther or not "/" is filtered out is a question, bit I would somehow bet it is.

这篇关于SQL Server 2005全文搜索 - 我可以搜索正斜杠字符吗？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！