Hi Kim,
On Thu, 2002-03-21 at 09:15, Kim Kohen wrote:
> G'day Arjen
Indeed, hi fellow Aussie ;-)
> > FULLTEXT search generally uses an index (the FULLTEXT index), so the
> > server will not use an index on Writer.
> So is an index on Writers worthless in this circumstance? My concern would
> b
G'day Arjen
> FULLTEXT search generally uses an index (the FULLTEXT index), so the
> server will not use an index on Writer.
> So far for the answer to Kim.
So is an index on Writers worthless in this circumstance? My concern would
be if someone did a query using the writer's name as the _on
On Wed, 2002-03-20 at 12:56, Paul DuBois wrote:
> >With Story_Content, we're happy to use the stricter MATCH selects. So is
> >it possible to do something like Select * from stories where
> >MATCH(Story_Content) against ('param1') AND Writer LIKE "param2%" or am I
> >barking up the wrong (b-) tr
At 13:28 +1100 3/20/02, Kim Kohen wrote:
>G'day Paul
>
>Thank you for your response.
>
>> Sure, but no index will be used for the LIKE pattern match part of the
>> query because your pattern doesn't begin with a literal string.
>
>I realised after I sent the previous post that I should have
G'day Paul
Thank you for your response.
> Sure, but no index will be used for the LIKE pattern match part of the
> query because your pattern doesn't begin with a literal string.
I realised after I sent the previous post that I should have omitted the
first '%'. I had mentally noted this f
At 11:59 +1100 3/20/02, Kim Kohen wrote:
>Hi All,
>
>My apologies for asking what may be a very newbie question. I'm having
>trouble getting my head around searching multiple indexed columns. I have
>read the MySQL docs 5.4.3, 5.4.4, 5.4.5 and 6.8 full text and have scoured
>Paul's book but haven'
Hi All,
My apologies for asking what may be a very newbie question. I'm having
trouble getting my head around searching multiple indexed columns. I have
read the MySQL docs 5.4.3, 5.4.4, 5.4.5 and 6.8 full text and have scoured
Paul's book but haven't been able to find an answer.
We have a table
Hi All,
My apologies for asking what may be a very newbie question. I'm having
trouble getting my head around searching multiple indexed columns. I have
read the MySQL docs 5.4.3, 5.4.4, 5.4.5 and 6.8 full text and have scoured
Paul's book but haven't been able to find an answer.
We have a table
