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("" IN BOOLEAN MODE);
title
DROP TABLE diaries;
