Check out example codes for "regexp sql". It will help you in understanding the concepts better.

Code Example 1

mysql> SELECT FirstName FROM intque.person_tbl WHERE FirstName REGEXP '^[aeiou].*ok$';

Code Example 2

SELECT name FROM student_tbl WHERE name REGEXP '^sa';

Learn ReactJs, React Native from akashmittal.com