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
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
