The REGEXP (or its synonym, RLIKE) operator allows pattern matching based on regular expressions.
Consider the following employee table:
+-------------+-------------+-------------+--------------+----------+
| EMPLOYEE_ID | FIRST_NAME | LAST_NAME | PHONE_NUMBER | SALARY |
+-------------+----...