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!