Someone asked me to look up how to regular expressions in mysql. I hadn't ever done that before, but it is pretty simple. I thought I would forward it here in case someone finds it useful someday. select slug from plog_articles WHERE slug REGEXP 'one[-]*r[-]*c';