达梦TEXT类型字段的模糊查询

2021-11-18 593 阅读1分钟

创建全文索引

create context index CONTEXT_a_CONTENT
on a(CONTENT)
lexer CHINESE_FP_LEXER sync transaction;

验证全文索引查询

 SELECT *
 FROM a 
 WHERE CONTAINS(a.CONTENT,'测试')