%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") 会找到任何里面有book"的东西，包括rebooked"或类似的东西.
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*"')
相关文章