EVOLUTION-MANAGER

Edit File: create_table_index_normalizer_parameter.result

DROP TABLE IF EXISTS memos; SET NAMES utf8; CREATE TABLE memos ( id INT NOT NULL PRIMARY KEY, content TEXT NOT NULL, FULLTEXT INDEX (content) NORMALIZER='NormalizerAuto' ) DEFAULT CHARSET=utf8; SHOW CREATE TABLE memos; Table Create Table memos CREATE TABLE `memos` ( `id` int(11) NOT NULL, `content` text NOT NULL, PRIMARY KEY (`id`), FULLTEXT KEY `content` (`content`) `NORMALIZER`='NormalizerAuto' ) ENGINE=Mroonga DEFAULT CHARSET=utf8 INSERT INTO memos VALUES (1, "1日の消費㌍は約2000㌔㌍"); SELECT * FROM memos WHERE MATCH (content) AGAINST ("+カロリー" IN BOOLEAN MODE); id content 1 1日の消費㌍は約2000㌔㌍ DROP TABLE memos;