Ben Edwards wrote:
On 21/06/07, Baron Schwartz <[EMAIL PROTECTED]> wrote:
Hi Ben,
Ben Edwards wrote:
> Can Mysql 4.20 use an index where like 'xx%' is in the where
> clause against the column.
>
> i.e. index table1(col1)
>
> from table1
> where table1.col1 like 'something%'
Yes, it can use
Hi Ben,
Ben Edwards wrote:
Can Mysql 4.20 use an index where like 'xx%' is in the where
clause against the column.
i.e. index table1(col1)
from table1
where table1.col1 like 'something%'
Yes, it can use an index on LIKE prefixes. Using a function such as LEFT(col1, 9) =
'something' wil
