Hello
I have created a table:
CREATE TABLE data (no int auto_increment, topic text, author text, date date,
description text, file text, note longtext, name varchar(15), password (15),
folder text, key(no), FULLTEXT(topic,author,description,file,note));
Then, I would like to a FULLTEXT SEARCH in ONE (or 2 or 3) field:
ex: SELECT * FROM data WHERE MATCH(note) AGAINTS("text to find");
error 1191: can't find FULLTEXT index matching the column list
same problem for MATCH(note,author), by example
That works only when I do MATCH(topic,author,description,file,note), so with
all the fields in fulltext. But that's not what I would like to do.
When I see the error message, I tried to create an other index:
ALTER TABLE data ADD key(note);
error 1170: BLOB column 'note' used in key specification without a key length
I have the same problem with IN BOOLEAN MODE.
I'm using MySQL 3.23.51
What should I do to use the FULLTEXT search in the desired number of fields?
Thank you for your help
Julien Sobrier
---------------------------------------------------------------------
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
