List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:November 25 2002 8:59pm
Subject:Re: Does FULLTEXT work in mysql-3.23.49?
View as plain text  
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, johnl@stripped, Primary Perpetrator of "The Internet 
>for Dummies",
>Information Superhighwayman wanna-be, http://iecc.com/johnl, Sewer 
>Commissioner
>"I dropped the toothpaste", said Tom, crestfallenly.

Thread
Does FULLTEXT work in mysql-3.23.49?John R Levine25 Nov
  • Re: Does FULLTEXT work in mysql-3.23.49?Paul DuBois25 Nov