>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
>'%c%'" or
>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/
| Thread |
|---|
| • LIKE vs. REGEXP | Simson Garfinkel | 4 Jul |
| • Re: LIKE vs. REGEXP | Paul DuBois | 4 Jul |
