>If I'm searching through 200K strings, and they are indexed, is it more
>efficient to use "string like '%a%' or string like '%b%' or string like
>to use 'string regexp [aA][bB][cC]'
Indexes aren't used if your pattern begins with %, so it doesn't matter
if they're indexed or not for the examples you give. Don't know which
is faster, though. The empirical test is in order.
Paul DuBois, paul@stripped
Northern League Chronicles: http://www.snake.net/nl/
|• LIKE vs. REGEXP||Simson Garfinkel||4 Jul|
| • Re: LIKE vs. REGEXP||Paul DuBois||4 Jul|