blob: 96d92e535d2e1756b3d7772de9a3434e3f21b4fd (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
|
DROP TABLE IF EXISTS memos;
SET NAMES utf8;
CREATE TABLE memos (
id INT PRIMARY KEY AUTO_INCREMENT,
content TEXT,
FULLTEXT INDEX (content)
) DEFAULT CHARSET=utf8 COMMENT='engine "InnODB"';
INSERT INTO memos VALUES (NULL, "Today is good day.");
INSERT INTO memos VALUES (NULL, "Tomorrow will be good day.");
INSERT INTO memos VALUES (NULL, "Today is fine.");
INSERT INTO memos VALUES (NULL, "Tomorrow will be fine.");
INSERT INTO memos VALUES (NULL, "Yesterday was fine.");
SELECT * FROM memos
WHERE MATCH (content) AGAINST ("*DOR today good" IN BOOLEAN MODE)
ORDER BY id;
id content
1 Today is good day.
2 Tomorrow will be good day.
3 Today is fine.
DROP TABLE memos;
|