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, "Today is fine.");
11SELECT * FROM memos
12WHERE MATCH (content) AGAINST ("*D+ today OR tomorrow day" IN BOOLEAN MODE);
13id	content
141	Today is good day.
152	Tomorrow will be good day.
16DROP TABLE memos;
17