FreeText 判断字 ,可提供意思上的相关匹配搜索。FreeText(搜索字段,搜索短语)
例:
Select username from member where freeText(userinfo,'作家')
FreeTextTable 函数,FreeTextTable(要搜索的表名,搜索字段,搜索短语),提供意思上的相关匹配搜索,返回的结果也是一个表,同ContainsTable函数。
例:
Select Rank,username from member inner join FreeTextTable(member,userinfo,'worker') as sr on userid=[key] order by rank desc
首先在安装SQLSERVER时选择Full-Text Search Service
然后在对要索引的表中加入全文本索引,执行全文本搜索时
还要必须加入新的判断字和两个函数
constains containstable and freetext freetexttable
example:
SELECT content
FROM news
WHERE FREETEXT ( content, 'Mobile')