DROP TABLE IF EXISTS memos;
SET NAMES utf8;
CREATE TABLE memos (
content TEXT,
FULLTEXT INDEX (content)
) DEFAULT CHARSET=utf8;
INSERT INTO memos VALUES ("Today is good day.");
INSERT INTO memos VALUES ("Tomorrow will be good day.");
INSERT INTO memos VALUES ("Today is fine.");
INSERT INTO memos VALUES ("Tomorrow will be fine.");
INSERT INTO memos VALUES ("Yesterday was fine.");
SELECT * FROM memos
WHERE MATCH (content) AGAINST ("*DOR today -good tomorrow" IN BOOLEAN MODE);
content
Tomorrow will be good day.
Today is fine.
Tomorrow will be fine.
DROP TABLE memos;
