mysql string match regex code example

Example 1: mysql regexp match word

SELECT *
FROM table 
WHERE keywords REGEXP '[[:<:]]rid[[:>:]]'

Example 2: mysql regex exact match

select * from user where first_name REGEXP '^john$';