EVOLUTION-MANAGER

Edit File: fulltext_or.result

DROP TABLE IF EXISTS diaries; SET NAMES UTF8; CREATE TABLE diaries( title TEXT, FULLTEXT KEY (title) ) DEFAULT CHARSET=utf8; INSERT INTO diaries VALUES("Start groonga"); INSERT INTO diaries VALUES("Start mroonga"); INSERT INTO diaries VALUES("Start groonga and Ruby"); SELECT * FROM diaries; title Start groonga Start mroonga Start groonga and Ruby SELECT * FROM diaries WHERE MATCH(title) AGAINST("Ruby" IN BOOLEAN MODE) OR MATCH(title) AGAINST("mroonga" IN BOOLEAN MODE); title Start mroonga Start groonga and Ruby DROP TABLE diaries;