regexp in 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[[:>:]]'
mysql> SELECT FirstName FROM intque.person_tbl WHERE FirstName REGEXP '^[aeiou].*ok$';
SELECT *
FROM table
WHERE keywords REGEXP '[[:<:]]rid[[:>:]]'