MySQL uses POSIX 1003.2 style REGEX rules NOT Perl.
So using \b for word boundries is rather futile. Use [[:<:]]word[[:>:]] instead.
Good stuff to know for the future so that I can avoid spending 40min trying to figure out why an expression is failing.
So using \b for word boundries is rather futile. Use [[:<:]]word[[:>:]] instead.
Good stuff to know for the future so that I can avoid spending 40min trying to figure out why an expression is failing.