Re: Problem With FulltText Index and VarChar

2005-12-30 Thread Michael Stearne
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 fie

Re: Problem With FulltText Index and VarChar

2005-12-30 Thread Gleb Paharenko
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... If I've got your question right, you shouldn't worry about it. As far as I know, the search is done against the union of all col

Re: Problem With FulltText Index and VarChar

2005-12-29 Thread Michael Stearne
On 12/28/05, Gleb Paharenko <[EMAIL PROTECTED]> wrote: > Hello. > > > #1054 - Unknown column 'CommentsIDX' in 'where clause' > > My table structure contains:FULLTEXT KEY `CommentsIDX` >(`Comments`) > > You should use column names not index names in your queries. Please, > provide CREATE stateme

Re: Problem With FulltText Index and VarChar

2005-12-28 Thread Gleb Paharenko
Hello. > #1054 - Unknown column 'CommentsIDX' in 'where clause' > My table structure contains:FULLTEXT KEY `CommentsIDX` >(`Comments`) You should use column names not index names in your queries. Please, provide CREATE statement for your tables and problematic queries. With this inform