[ubuntu-florida] MySQL and REGEX

Dan Trevino dantrevino at gmail.com
Tue Sep 21 18:29:38 BST 2010


Very nice.
> On Tue, Sep 21, 2010 at 10:38 AM, j.e.aneiros <jesus.aneiros at gmail.com>
wrote:
>> "A regular expression is a powerful way of specifying a pattern for a
>> complex search." (Excerpt from MySQL manual:
>> http://dev.mysql.com/doc/refman/5.1/en/regexp.html)
>
> Something to keep in mind about using a regex on a column is the mysql
> query optimizer will not use any of the available indexes, instead
> reverting to a full table scan. So while these are good for one-off
> queries like the one described here, one should be mindful before
> putting it into a production system that gets hit a lot.
>
>
> -Ryan
> (stickystyle)
>
> --
> Ubuntu-us-fl mailing list
> Ubuntu-us-fl at lists.ubuntu.com
> Modify settings or unsubscribe at:
https://lists.ubuntu.com/mailman/listinfo/ubuntu-us-fl
-------------- next part --------------
An HTML attachment was scrubbed...
URL: https://lists.ubuntu.com/archives/ubuntu-us-fl/attachments/20100921/dfbfafb9/attachment.htm 


More information about the Ubuntu-us-fl mailing list