全文索引

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for `bookmarks`
-- ----------------------------
DROP TABLE IF EXISTS `bookmarks`;
CREATE TABLE `bookmarks` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(75) NOT NULL,
`url` varchar(200) NOT NULL,
`description` mediumtext NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `name` (`name`,`url`),
FULLTEXT KEY `description` (`description`)
) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of bookmarks
-- ----------------------------
INSERT INTO `bookmarks` VALUES ('1', 'Python.org', 'www.python.org', 'The official Python Web site');
INSERT INTO `bookmarks` VALUES ('2', 'MySQL manual', 'http://dev.mysql.com/doc', 'The MySQL reference manual');
INSERT INTO `bookmarks` VALUES ('3', 'Apache site', 'http://httpd.apache.org', 'Includes Apache 2 manual');
INSERT INTO `bookmarks` VALUES ('4', 'PHP:Hypertext', 'www.php.net', 'The official PHP Web site');
INSERT INTO `bookmarks` VALUES ('5', 'Apache Week', 'www.apacheweek.com', 'Offers a dedicated Apache 2 section');

SELECT name,url FROM bookmarks WHERE MATCH(description) AGAINST('Apache 2');