regexp lik not handling errors in mysql 8 code example Example: mysql regexp match word SELECT * FROM table WHERE keywords REGEXP '[[:<:]]rid[[:>:]]'