mysql 全文检索 不管用 无效
表如下:
CREATE TABLE `text` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`text` varchar(255) COLLATE utf8_bin DEFAULT NULL,
`title` varchar(255) COLLATE utf8_bin DEFAULT NULL,
PRIMARY KEY (`id`),
FULLTEXT KEY `fulltext_index` (`text`,`title`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='全文索引测试';
INSERT INTO `text` VALUES (1,'ni shi shui a?','wo hao xiang mei jian guo ni.');
INSERT INTO `text` VALUES (2,'ni wen wo shi shui a.','wo ye mei jian guo ni a.');
语句如下:
SELECT * from text where match(text,title) AGAINST("ni")
结果:
神马都没有啊,相似度竟然是一串0,郁闷了,求高手指点迷津啊,谢谢了!