SQL Server 2005。全文搜索。需要使用NEAR/AND/OR关键字的同义词

Question

有没有人知道是否可以使用NEAR或AND/OR关键字一起进行同义词搜索。下面是我想要运行的查询类型的示例：

    SELECT Title, RANK
            FROM Item INNER JOIN
            CONTAINSTABLE(Item, Title, 'FORMSOF(Thesaurus, "red" NEAR "wine")') AS KEY_TBL
            ON Item.ItemID = KEY_TBL.[KEY]
    ORDER BY RANK DESC

....But我收到错误消息：

在全文搜索条件‘FORMSOF(同义词库，“红色”，“酒”)“中的' near’附近出现语法错误。”

Answer 1

Near和FormsOf彼此不能很好地协同工作。请阅读以下链接Is it possible to combine NEAR and FORMSOF together in a fulltext search?

使用IsAbout

SELECT   K.RANK, name, Description
FROM      Diagnosis AS C
INNER JOIN
CONTAINSTABLE(diagnosis,name, 'ISABOUT (
FORMSOF(Thesaurus, "red"),
FORMSOF(Thesaurus, "wine"))', 50) AS K
ON C.ID = K.[KEY];
GO

Answer 2

同义词库的语法略有不同，您可能要查找的内容如下：

SELECT Title, RANK
            FROM Item INNER JOIN
            CONTAINSTABLE(Item, Title, 'FORMSOF(Thesaurus, "red") NEAR FORMSOF(Thesaurus, "wine")') AS KEY_TBL
            ON Item.ItemID = KEY_TBL.[KEY]
    ORDER BY RANK DESC