DROP TABLE IF EXISTS Bugs, Tags;
CREATE TABLE Tags (
name VARCHAR(64) PRIMARY KEY
) DEFAULT CHARSET=utf8
COLLATE=utf8_bin
COMMENT='default_tokenizer "TokenDelimit"';
CREATE TABLE Bugs (
id INT UNSIGNED PRIMARY KEY,
tags VARCHAR(40) COMMENT 'type "Tags", flags "COLUMN_VECTOR"',
FULLTEXT INDEX bugs_tags_index (tags) COMMENT 'table "Tags"'
) DEFAULT CHARSET=utf8;
INSERT INTO Bugs (id, tags) VALUES (1, "Linux MySQL");
INSERT INTO Bugs (id, tags) VALUES (2, "MySQL groonga");
INSERT INTO Bugs (id, tags) VALUES (3, "mroonga");
SELECT *
FROM Bugs
WHERE MATCH (tags) AGAINST ("MySQL" IN BOOLEAN MODE);
id	tags
1	Linux MySQL
2	MySQL groonga
DROP TABLE Bugs, Tags;
