List:General Discussion« Previous MessageNext Message »
From:Michael Widenius Date:September 17 1999 8:33pm
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.

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