List:MySQL on Win32« Previous MessageNext Message »
From:Simson Garfinkel Date:July 4 1999 6:03pm
Subject:LIKE vs. REGEXP
View as plain text  

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]'

?


Thread
LIKE vs. REGEXPSimson Garfinkel4 Jul
  • Re: LIKE vs. REGEXPPaul DuBois4 Jul