全书目录/索引搜索％book％ [英] Full text catalog/index search for %book%

问题描述

我试图围绕如何搜索出现在词/表达式中间的东西 - 例如搜索LIKE％book％ - 但是在SQL Server（2005）全文目录中。

I'm trying to wrap my head around how to search for something that appears in the middle of a word / expression - something like searching for "LIKE %book% " - but in SQL Server (2005) full text catalog.

我该怎么做？它几乎看起来好像在开始 CONTAINS 和 FREETEXT 真的不支持通配符>的搜索表达式 - 真的可以吗？

How can I do that? It almost appears as if both CONTAINS and FREETEXT really don't support wildcard at the beginning of a search expression - can that really be?

我会想象 FREETEXT（*，book）会找到里面有书的东西，包括重新预订或类似的东西。

I would have imagined that FREETEXT(*, "book") would find anything with "book" inside, including "rebooked" or something like that.

推荐答案

不幸的是，CONTAINS仅支持前缀通配符：

unfortunately CONTAINS only supports prefix wildcards:

CONTAINS(*, '"book*"')

这篇关于全书目录/索引搜索％book％的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！