blob: 767fe491e990d8e1baa4fff50feae98d5d3bcf3c (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
|
CREATE TABLE terms (
name VARCHAR(64) PRIMARY KEY
) DEFAULT CHARSET=utf8
COMMENT='default_tokenizer "TokenBigram"';
CREATE TABLE bugs (
id INT UNSIGNED PRIMARY KEY,
title TEXT,
FULLTEXT INDEX (title) COMMENT 'table "terms"'
) DEFAULT CHARSET=utf8;
INSERT INTO bugs (id, title) VALUES (1, "Mroonga can't build with MySQL X.Y.Z");
SELECT * FROM terms ORDER BY name;
name
'
.
BUILD
CAN
MROONGA
MYSQL
T
WITH
X
Y
Z
SELECT *, MATCH (title) AGAINST ("+MySQL" IN BOOLEAN MODE) AS score
FROM bugs
WHERE MATCH (title) AGAINST ("+MySQL" IN BOOLEAN MODE);
id title score
1 Mroonga can't build with MySQL X.Y.Z 1
DROP TABLE bugs;
DROP TABLE terms;
|
