At 13:57 -0500 11/25/02, John R Levine wrote:
I'm trying to make what I think is a very simple fulltext index for a small library catalog, viz:create table library ( id INTEGER UNSIGNED PRIMARY KEY NOT NULL, callnumber VARCHAR(8) NOT NULL, lastname TINYTEXT, firstname TINYTEXT, middlename TINYTEXT, title TINYTEXT NOT NULL, subtitle TINYTEXT, comments TINYTEXT, publisher TINYTEXT, year VARCHAR(6) NOT NULL, media VARCHAR(20), FULLTEXT(lastname,firstname,title,subtitle,comments,publisher) ); I load a few hundred records in and then try to search. mysql> select * from library where match(title,subtitle) against ('history'); ERROR 1191: Can't find FULLTEXT index matching the column list
Your index contains a different set of columns than the columns listed in the match() list. You'll need to create another FULLTEXT index containing just title and subtitle.
What am I doing wrong? Does it dislike tinytext?
Regards,
John Levine, [EMAIL PROTECTED], Primary Perpetrator of "The Internet for Dummies",
Information Superhighwayman wanna-be, http://iecc.com/johnl, Sewer Commissioner
"I dropped the toothpaste", said Tom, crestfallenly.
--------------------------------------------------------------------- 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
