Write a mysql statement to retrieve name beginning with 'm'

Solution

To apply extended regular expression, REGEXP operator is used with pattern matching characters.
To find names beginning with 'm', use ^ to match the beginning of the name. It returns 1 if the string expr matches the regular expression specified by the pattern 'm', 0 otherwise.

mysql> SELECT * FROM students
     -> WHERE name REGEXP '^m';

Output of the above statement -

+----+--------------+------------+------------+
| id | name         | department | birth      |
+----+--------------+------------+------------+
|  1 | Maria Gloria | CS         | 1994-03-12 |
|  6 | Maria Gaga   | EC         | 1993-10-09 |
+----+--------------+------------+------------+