Hi, I am having problems with the above error, which I get when trying to do this:
select name from category where match (name) against ('ipaq');
on this table:
Field Type Null Key Default Extra Privileges
id int(10) unsigned PRI NULL auto_increment
select,insert,update,references
name char(255) MUL select,insert,update,references
parent_id int(10) unsigned YES NULL
select,insert,update,references
import_tag char(64) YES NULL
select,insert,update,references
exclude tinyint(4) YES 0 select,insert,update,references
with these indices:
Table Non_unique Key_name Seq_in_index Column_name Collation
Cardinality Sub_part Packed Comment
category 0 PRIMARY 1 id A 4846 NULL NULL NULL
category 1 index1 1 name A NULL NULL NULL NULL
category 1 cs 1 name A NULL NULL NULL NULL
Can anyone shed any light on this problem. Just wondering why cs doesn't show up as
FULLTEXT in the Comment
field? It is definitely the only FULLTEXT index on the table, as trying to do a
fulltext search bofore creating
it (with CREATE INDEX) doesn't work (an error that there is no fulltext index).
Fulltext searching aslo works on a different table in the same database...
I am running version 3.23.31
Thanks,
KimS
---------------------------------------------------------------------
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
