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

Reply via email to