EVOLUTION-MANAGER

Edit File: alter_table_fulltext_add_normal.result

DROP TABLE IF EXISTS memos; CREATE TABLE memos ( id INT PRIMARY KEY AUTO_INCREMENT, content TEXT ) DEFAULT CHARSET="utf8"; INSERT INTO memos (content) values ("Starting Groonga..."); INSERT INTO memos (content) values ("Started Groonga."); INSERT INTO memos (content) values ("Starting Mroonga..."); ALTER TABLE memos ADD FULLTEXT INDEX content_index (content); SELECT * FROM memos WHERE MATCH(content) AGAINST("+groonga" IN BOOLEAN MODE); id content 1 Starting Groonga... 2 Started Groonga. DROP TABLE memos;