List:General Discussion« Previous MessageNext Message »
From:Michael Widenius Date:September 17 1999 8:33pm
Subject:REGEXP
View as plain text  
>>>>> "Orlando" == Orlando Andico <orly@stripped> writes:

Orlando> Hello,

Orlando> I am planning to make heavy use of REGEXP in queries. Is this efficient?
Orlando> is the index used in any way? how does it compare, performance-wise, to
Orlando> LIKE?

REGEXP will not use an index.  LIKE is faster if you have a prefix
(becuse it can use indexes in this case) but in other cases REGEXP
should be faster.

You can always test this with the MySQL BENCHMARK() function.

Regards,
Monty
Thread
REGEXPOrlando Andico15 Sep
  • BENCHMARK (was: REGEXP)Martin Ramsch16 Sep
    • Re: BENCHMARK (was: REGEXP)James Manning16 Sep
      • Re: BENCHMARK (was: REGEXP)Martin Ramsch17 Sep
  • REGEXPMichael Widenius18 Sep