On 12/30/05, Gleb Paharenko <[EMAIL PROTECTED]> wrote:
> Hello.
>
> > I guess my question is, how do I make sure the full text search is
> > being done against the CommentsIDX and not just against the individual
> > fields...
>
>
> This shows that the search is done against concatenation of the fields:
>
> mysql> select a, b, match(a,b) against('search words') from ab where
> match(a,b) against('+search +words' in boolean mode);
> +--------+-------+------------------------------------+
> | a | b | match(a,b) against('search words') |
> +--------+-------+------------------------------------+
> | search | words | 1.7514755725861 |
> +--------+-------+------------------------------------+
>
Thanks so much for your help. Everything makes sense. One this I did
come across though is that if you are using a multi-column index you
have to include all the columns in the index in your select statement.
e.g. MATCH (Comment, heading, ...)
Thanks,
Michael
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
