-
Notifications
You must be signed in to change notification settings - Fork 73
/
example-jieba.sql
12 lines (12 loc) · 888 Bytes
/
example-jieba.sql
1
2
3
4
5
6
7
8
9
10
11
12
select '';
select '';
select '--------------------------------------------------------------------------------';
select '使用jieba分词:';
-- will match
select ' ', simple_highlight(t1, 0, '[', ']') from t1 where x match simple_query('国中woai');
select ' ', simple_highlight(t1, 0, '[', ']') from t1 where x match jieba_query('中国woai');
-- will not match, in jieba_query, the order matters
select ' !!!! should not match', simple_highlight(t1, 0, '[', ']') from t1 where x match simple_query('国中woai', 0);
select ' !!!! should not match', simple_highlight(t1, 0, '[', ']') from t1 where x match jieba_query('国中woai');
select ' !!!! should not match', simple_highlight(t1, 0, '[', ']') from t1 where x match jieba_query('中国woai', 0);
select ' !!!! should not match', simple_highlight(t1, 0, '[', ']') from t1 where x match jieba_query('aiwo', 0);