search regex mysql code example
Example 1: regexp sql
mysql> SELECT FirstName FROM intque.person_tbl WHERE FirstName REGEXP '^[aeiou].*ok$';
Example 2: mysql regexp match word
SELECT *
FROM table
WHERE keywords REGEXP '[[:<:]]rid[[:>:]]'
Example 3: mysql regex exact match
select * from user where first_name REGEXP '^john$';