Re: LIKE vs. REGEXP - Paul DuBois - com.mysql.lists.win32

2 messages in com.mysql.lists.win32Re: LIKE vs. REGEXP

From	Sent On	Attachments
Simson Garfinkel	04 Jul 1999 11:03
Paul DuBois	04 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.