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