%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.

我该怎么做?看起来好像CONTAINSFREETEXT 真的不支持搜索表达式开头 的通配符——真的可以吗?

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") 会找到任何里面有book"的东西,包括rebo​​oked"或类似的东西.

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*"')

相关文章