Neil Tompkins wrote:
I followed the instructions, but when doing a search I get no results returned.
here is my table
CREATE TABLE /*!32300 IF NOT EXISTS*/ MyTest ( id int(10) unsigned NOT NULL
auto_increment, title varchar(200) , body text , PRIMARY KEY (id), INDEX
title (title,body));
I created FULL INDEX, but for some reason it is not showing above ?
Do a show create table tablename;
does it show up then?
A full text index will only be used once a table is populated (less than
3 or 4 rows it won't use it at all).
See http://dev.mysql.com/doc/refman/5.1/en/fulltext-search.html
and
http://dev.mysql.com/doc/refman/5.1/en/fulltext-restrictions.html
and finally some words will not be included in a full text search
automatically:
http://dev.mysql.com/doc/refman/5.1/en/fulltext-stopwords.html
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]