> >> 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 stated this.
Aha, I see that it has been corrected. In section 6.8.1 there's now a
second bullet that says:
* The MATCH() column list must exactly match the column list in some
FULLTEXT index definition for the table, unless this MATCH() is IN
BOOLEAN MODE.
That wasn't there when I downloaded 3.23.49.
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.
PS: sql query
---------------------------------------------------------------------
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
