1DROP TABLE IF EXISTS memos; 2SET NAMES utf8; 3CREATE TABLE memos ( 4id INT NOT NULL PRIMARY KEY, 5content TEXT NOT NULL, 6FULLTEXT INDEX (content) COMMENT 'normalizer "NormalizerAuto"' 7) COMMENT='ENGINE "InnoDB"' DEFAULT CHARSET=utf8 COLLATE=utf8_bin; 8SHOW CREATE TABLE memos; 9Table Create Table 10memos CREATE TABLE `memos` ( 11 `id` int(11) NOT NULL, 12 `content` text COLLATE utf8_bin NOT NULL, 13 PRIMARY KEY (`id`), 14 FULLTEXT KEY `content` (`content`) COMMENT 'normalizer "NormalizerAuto"' 15) ENGINE=Mroonga DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='ENGINE "InnoDB"' 16INSERT INTO memos VALUES (1, "1日の消費㌍は約2000㌔㌍"); 17SELECT * FROM memos 18WHERE MATCH (content) AGAINST ("+カロリー" IN BOOLEAN MODE); 19id content 201 1日の消費㌍は約2000㌔㌍ 21DROP TABLE memos; 22