CREATE TABLE `test` ( `id` int(11) NOT NULL COMMENT 'unique id', `text` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin ) ENGINE=InnoDB DEFAULT CHARSET=utf8; INSERT INTO `test` (`id`, `text`) VALUES (1288, 'i just don\'t know what to say.'), (1340, 'so what?'), (1344, 'that was probably what influenced their decision.'), (1345, 'i\'ve always wondered what it\'d be like to have siblings.'); ALTER TABLE `test` ADD FULLTEXT KEY `text` (`text`); select *, match(text) against ('what' IN BOOLEAN MODE) as hasWhat, match(text) against ('just' IN BOOLEAN MODE) as hasJust from test;
The match against "what" always returns 0 even though I'm using "IN BOOLEAN MODE." Why?