Hello,
I tried the FULLTEXT example from the manual
(http://www.mysql.com/doc/F/u/Fulltext_Search.html) and run across some
problems. On some search terms, I get a result set and others I do not.
The query -> SELECT * FROM articles WHERE MATCH (title,body) AGAINST
('database') returns a result, while the query -> SELECT * FROM articles
WHERE MATCH (title,body) AGAINST ('following') does not.
Also, how can I search for multiple search terms within a full text column
('database design' for example)?
Any ideas?
Thanks.
--Kevin
[EMAIL PROTECTED]
=================
CREATE TABLE `articles` (
`id` int(10) unsigned NOT NULL auto_increment,
`title` varchar(200) default NULL,
`body` text,
PRIMARY KEY (`id`),
FULLTEXT KEY `title` (`title`,`body`)
) TYPE=MyISAM;
INSERT INTO `articles` VALUES("1","MySQL Tutorial","DBMS stands for DataBase
...");
INSERT INTO `articles` VALUES("2","How To Use MySQL Efficiently","After you
went through a ...");
INSERT INTO `articles` VALUES("3","Optimising MySQL","In this tutorial we
will show ...");
INSERT INTO `articles` VALUES("4","1001 MySQL Trick","1. Never run mysqld as
root. 2. ...");
INSERT INTO `articles` VALUES("5","MySQL vs. YourSQL","In the following
database comparison ...");
INSERT INTO `articles` VALUES("6","MySQL Security","When configured
properly, MySQL ...");
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php