示例:
Contains,Freetext
select * from 表名 where Contains(列名,'关键字')
select * from 表名 where Freetext(列名,'关键字')
ContainsTable,FreetextTable
select * from ContainsTable(表名1,列名,'关键字') as a inner join 表名1 on a.[key]=id where id>10000
select * from FreetextTable(表名1,列名,'关键字') as a inner join 表名1 on a.[key]=id where id>10000
全文索引四个函数的运用
最新推荐文章于 2022-01-23 17:44:59 发布