REGEXP

[Michael Widenius]

>>>>> "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