regexp in select mysql 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$';
SELECT *
FROM table
WHERE keywords REGEXP '[[:<:]]rid[[:>:]]'
select * from user where first_name REGEXP '^john$';