SQL之全文檢索（一般用例）

最新推荐文章于 2024-09-27 11:31:35 发布

xndiy07

最新推荐文章于 2024-09-27 11:31:35 发布

阅读量368

点赞数

分类专栏：數據庫相關文章标签： sql table join oracle

本文链接：https://blog.csdn.net/xndiy07/article/details/3503430

版权

數據庫相關专栏收录该内容

2 篇文章 0 订阅

订阅专栏

先設置好表的全文檢索，并填充,以下是相關SQL CODE，可供參考

SELECT * FROM Users

SELECT * FROM Users
         WHERE CONTAINS(Unote,'"北京" NEAR " sql"')
UNION ALL
SELECT * FROM Users
         WHERE FREETEXT(Unote,'sql 北京 ') and id not in(SELECT id FROM Users
         WHERE CONTAINS(Unote,'"北京" NEAR " sql"'))

SELECT * FROM Users
         WHERE FREETEXT(Unote,'sql 北京 ')
SELECT * FROM Users
         WHERE CONTAINS(Unote,'"北京" NEAR " sql" NEAR "oracle"')
SELECT * FROM
         CONTAINSTABLE(Users,Unote,'北京') as table1
SELECT * FROM Users JOIN
         CONTAINSTABLE(Users,Unote,' "大學" NEAR "sql" ',10) as table1
         ON Users.[id]= table1.[KEY]
         ORDER BY table1.RANK DESC
SELECT * FROM Users JOIN
         FREETEXTTABLE(Users,Unote,' 大學 sql ',10) as table1
         ON Users.[id]= table1.[KEY]
         ORDER BY table1.RANK DESC