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