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
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
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
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
I am trying to do a fulltext search with a multi-field index using MySQL 4.1.15.
When I create a full text index of my Comments field which is of type
TEXT. I can do a fulltext search fine.
But when I add another field (like a varchar or even Text) to that
index or change the name of the index I
