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