At 2:05 PM -0400 2000-07-04, Ilia Lobsanov wrote:
>I am having a problem whereby I must use a SUBSTRING_INDEX in a query, but
>it slows it down tremendously (>100%). The column that the substring_index
>is acted upon *is* indexed.
The column itself might be indexed, but as soon as you apply a function
to a column value, the index can no longer be indexed. MySQL must retrieve
each value, apply the function to it, and then determine whether the
resulting value satisfies the condition you're testing.
>
>Does MySQL just not support using the column index in conjuction with
>SUBSTRING_INDEX?
>Is this a bug or just me?
It's not a bug.
--
Paul DuBois, paul@stripped
