2 messages in com.mysql.lists.win32Re: LIKE vs. REGEXP
FromSent OnAttachments
Simson Garfinkel04 Jul 1999 11:03 
Paul DuBois04 Jul 1999 11:19 
Subject:Re: LIKE vs. REGEXP
From:Paul DuBois (pa@snake.net)
Date:07/04/1999 11:19:09 AM
List:com.mysql.lists.win32

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.