sql pattern matching regex code example
Example 1: regexp sql
mysql> SELECT FirstName FROM intque.person_tbl WHERE FirstName REGEXP '^[aeiou].*ok$';Example 2: How is the pattern matching done in the SQL?
SELECT * from Emp WHERE name like ‘b%’;mysql> SELECT FirstName FROM intque.person_tbl WHERE FirstName REGEXP '^[aeiou].*ok$';SELECT * from Emp WHERE name like ‘b%’;