mysql PREG CAPTURE between words examples

Example: mysql regex exact match

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