Thanx Chris. That was it. To save space, I went ahead and dropped the two separate indexes because they were no longer needed. The only fulltext search performed on this database includes both fields.
Thanx again, Robb On Fri, 21 May 2004 13:42:21 -0700, Chris wrote: > What query are you using to search? > > With the FullText indexes you have only two match options are possible: > > MATCH(specs) AGAINST . . . > > and > > MATCH(manufacturer) AGAINST . . . > > If you're trying to search both at the same time you need a FULLTEXT > index of (specs,manufacturer) > > Chris > > Robb Kerr wrote: > >>Got a problem with my fulltext searches. Here is the structure of the table >>as displayed in MySQLyog... >> >>Column Information For - robeson_robesondb.robeson_inv >>------------------------------------------------------ >> >>Field Type Null Key Default Extra Privileges >> >>------------ ------- ------ ------ ------- -------------- >>------------------------------- >>ID int(11) PRI (NULL) auto_increment >>select,insert,update,references >>manufacturer text YES MUL (NULL) >>select,insert,update,references >>model text YES (NULL) >>select,insert,update,references >>specs text YES MUL (NULL) >>select,insert,update,references >>qty int(11) YES (NULL) >>select,insert,update,references >>picture text YES (NULL) >>select,insert,update,references >> >>Index Information For - robeson_robesondb.robeson_inv >>----------------------------------------------------- >> >>Table Non_unique Key_name Seq_in_index Column_name >>Collation Cardinality Sub_part Packed Null Index_type Comment >>----------- ---------- ------------ ------------ ------------ >>--------- ----------- -------- ------ ------ ---------- ------- >>robeson_inv 0 PRIMARY 1 ID A >>949 (NULL) (NULL) BTREE >>robeson_inv 0 ID 1 ID A >>949 (NULL) (NULL) BTREE >>robeson_inv 1 specs 1 specs A >>316 (NULL) (NULL) YES FULLTEXT >>robeson_inv 1 manufacturer 1 manufacturer A >>316 (NULL) (NULL) YES FULLTEXT >> >>DDL Information For - robeson_robesondb.robeson_inv >>--------------------------------------------------- >> >>Table Create Table >> >> >> >>----------- >>--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- >>robeson_inv CREATE TABLE `robeson_inv` ( >> >> >> >> `ID` int(11) NOT NULL auto_increment, >> >> >> >> `manufacturer` text, >> >> >> >> `model` text, >> >> >> >> `specs` text, >> >> >> >> `qty` int(11) default NULL, >> >> >> >> `picture` text, >> >> >> >> PRIMARY KEY (`ID`), >> >> >> >> UNIQUE KEY `ID` (`ID`), >> >> >> >> FULLTEXT KEY `specs` (`specs`), >> >> >> >> FULLTEXT KEY `manufacturer` (`manufacturer`) >> >> >> >> ) TYPE=MyISAM >> >>As you can see, I've created a fulltext index for the "manufacturer" field. >>However, when I conduct a search, I get the following error message >>returned... >> >>Can't find FULLTEXT index matching the column list >> >>What's the problem? >> >>Thanx in advance, >>Robb >> >> >> -- Robb Kerr Digital IGUANA Helping Digital Artists Achieve their Dreams http://www.digitaliguana.com http://www.cancerreallysucks.org -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
