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."); 11INSERT INTO memos VALUES (NULL, "Tomorrow will be fine."); 12INSERT INTO memos VALUES (NULL, "Yesterday was fine."); 13SELECT * FROM memos 14WHERE MATCH (content) AGAINST ("*DOR today -good tomorrow" IN BOOLEAN MODE) 15ORDER BY id; 16id content 172 Tomorrow will be good day. 183 Today is fine. 194 Tomorrow will be fine. 20DROP TABLE memos; 21