MySql tip of the day

Posted by phillip Wed, 01 Mar 2006 11:58:00 GMT

using regular expressions for criteria

SELECT style_number, LENGTH(style_number) 
FROM articles 
WHERE style_number REGEXP '^(89|98)[0-9]+$'

you can also use RLIKE. and it runs much faster than expected, too!

Posted in | Tags