Re Does FULLTEXT work in mysql-3.23.49?

> >> 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. > > >Oh, OK. The manual needs to be corrected. > > Can you be more specific? I thought the manual already

Re: Re: Does FULLTEXT work in mysql-3.23.49?

> 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. Oh, OK. The manual needs to be corrected. Regards, John Levine, [EMAIL PROTECTED], Primary Perpetrator of "The Inter

Does FULLTEXT work in mysql-3.23.49?

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,

MySQL 3.23 problems on BSDI 4.1

e the prebuilt 4.2 binaries, because I'm not running 4.2 yet.) -- John R. Levine, IECC, POB 727, Trumansburg NY 14886 +1 607 387 6869 [EMAIL PROTECTED], Village Trustee and Sewer Commissioner, http://iecc.com/johnl, Member, Provisional board, Coalition Against Unsolicited Commerc