表如下:
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,郁闷了,求高手指点迷津啊,谢谢了!
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,郁闷了,求高手指点迷津啊,谢谢了!
全文检索可以用MySQL(但不限于)这类RDB。真想用全文检索功能,用开源的吧,如果是关键性项目,用个现成的商业版也行。