List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:January 31 2003 6:44pm
Subject:Re: Fulltext Index
View as plain text  
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

Thread
Fulltext IndexR. Hannes Niedner30 Jan
  • Re: Fulltext IndexPaul DuBois31 Jan
  • Re: Fulltext IndexDiana Soares31 Jan
    • Re: Fulltext IndexR. Hannes Niedner31 Jan