Re: Fulltext Index

[Paul DuBois]

At 13:40 -0800 1/30/03, R. Hannes Niedner wrote:
>If I create a FULLTEXT index for 2 or more columns in a table will I be able
>to use it for a MATCH only against a single column (of the above) or do I
>have to create additional FULLTEXT indices for each of these columns?

The latter.  When you use MATCH, there must be a FULLTEXT index
on exactly the columns named in the MATCH.

>
>Thanks/h
>
>sql,query,queries,smallint