1DROP TABLE IF EXISTS memos; 2SET NAMES utf8; 3CREATE TABLE memos ( 4content TEXT, 5FULLTEXT INDEX (content) 6) DEFAULT CHARSET=utf8; 7INSERT INTO memos VALUES ("Today is good day."); 8INSERT INTO memos VALUES ("Tomorrow will be good day."); 9INSERT INTO memos VALUES ("Yesterday was good day."); 10INSERT INTO memos VALUES ("Today is fine."); 11INSERT INTO memos VALUES ("Tomorrow will be fine."); 12INSERT INTO memos VALUES ("Yesterday was fine."); 13SELECT * FROM memos 14WHERE MATCH (content) AGAINST ("*D- fine is be" IN BOOLEAN MODE); 15content 16Yesterday was fine. 17DROP TABLE memos; 18