EVOLUTION-MANAGER

Edit File: fulltext_boolean_mode_escape.result

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;