1,建立全文索引后,我用解释计划分析:
select * from t where contains(docs,'%USE',1)>0;
和
select * from t where contains(docs,'USE',1)>0;
的分析结果是一样的,但感觉不对啊
2,这几个符号的用途和区别:
$,%,*select * from t where contains(docs,'$USE',1)>0;
select * from t where contains(docs,'USE$',1)>0;
select * from t where contains(docs,'%USE',1)>0;
select * from t where contains(docs,'USE%',1)>0;
select * from t where contains(docs,'*USE',1)>0;
select * from t where contains(docs,'USE*',1)>0;
3,如何定制USER_LEXER词法分析器?
4,如果contains(docs,'%USE',1)>0效率低的话,如何实现模糊匹配?
比如 手机号码 13856634567 , 要按照5663查询来
select * from t where contains(docs,'%USE',1)>0;
和
select * from t where contains(docs,'USE',1)>0;
的分析结果是一样的,但感觉不对啊
2,这几个符号的用途和区别:
$,%,*select * from t where contains(docs,'$USE',1)>0;
select * from t where contains(docs,'USE$',1)>0;
select * from t where contains(docs,'%USE',1)>0;
select * from t where contains(docs,'USE%',1)>0;
select * from t where contains(docs,'*USE',1)>0;
select * from t where contains(docs,'USE*',1)>0;
3,如何定制USER_LEXER词法分析器?
4,如果contains(docs,'%USE',1)>0效率低的话,如何实现模糊匹配?
比如 手机号码 13856634567 , 要按照5663查询来
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货