1DROP TABLE IF EXISTS memos;
2SET NAMES utf8;
3CREATE TABLE memos (
4id INT PRIMARY KEY AUTO_INCREMENT,
5content TEXT,
6FULLTEXT INDEX (content)
7) DEFAULT CHARSET=utf8 COMMENT='engine "InnODB"';
8INSERT INTO memos VALUES (NULL, "Today is good day.");
9INSERT INTO memos VALUES (NULL, "Tomorrow will be good day.");
10INSERT INTO memos VALUES (NULL, "Yesterday was good day.");
11INSERT INTO memos VALUES (NULL, "Today is fine.");
12INSERT INTO memos VALUES (NULL, "Tomorrow will be fine.");
13INSERT INTO memos VALUES (NULL, "Yesterday was fine.");
14SELECT * FROM memos
15WHERE MATCH (content) AGAINST ("*D- good +day be" IN BOOLEAN MODE);
16id	content
171	Today is good day.
183	Yesterday was good day.
19DROP TABLE memos;
20