blob: 5beda03ceb6958616687ee1cbcbfc39d15003de4 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
|
DROP TABLE IF EXISTS memos;
SET GLOBAL mroonga_default_tokenizer = TokenDelimit;
SET NAMES UTF8;
CREATE TABLE memos (
id INT PRIMARY KEY,
content TEXT,
FULLTEXT INDEX (content)
) DEFAULT CHARSET=UTF8;
INSERT INTO memos VALUES(1, "(groonga) Installed!");
INSERT INTO memos VALUES(2, "(mroonga) Installed!");
INSERT INTO memos VALUES(3, "(groonga) Upgraded!");
SELECT * FROM memos
WHERE MATCH(content) AGAINST("\\(groonga\\)*" IN BOOLEAN MODE);
id content
1 (groonga) Installed!
3 (groonga) Upgraded!
DROP TABLE memos;
SET GLOBAL mroonga_default_tokenizer = TokenBigram;
|