Q:

Write a mysql statement to get name of students containing exactly four characters

belongs to collection: MySQL Exercises

YasminRadwan26
Save to bookmark
|
2022-05-14
|
  217 
0

Write a mysql statement to get name of students containing exactly four characters

Suppose the student table is -

 
+----+-------+---------+------------+
| id | name  | dept_id | birth      |
+----+-------+---------+------------+
|  1 | Maria | 2       | 1994-03-12 |
|  2 | John  | 1       | 1993-02-07 |
|  3 | Gal   | 4       | 1992-09-11 |
|  4 | Jakey | 2       | 1990-08-31 |
|  5 | Rama  | 1       | 1994-12-09 |
|  6 | Maria | 4       | 1993-10-09 |
+----+-------+---------+------------+
Sql programming,
login and add your own answer to this question

All Answers

YasminRadwan26
2022-05-14
need an explanation for this answer? contact us directly to get an explanation for this answer

Solution

To apply extended regular expression REGEXP operator is used with pattern matching characters. The caret (^) is used to start the match at the beginning of string. The [...] matches any character between the square bracket. The caret ($) is used to start the match at the end of string.

The following statement retrieves the name of students containing exactly four characters.

mysql> SELECT * FROM student where name REGEXP '^....$';

Output of the above statement -

+----+------+---------+------------+
| id | name | dept_id | birth      |
+----+------+---------+------------+
|  2 | John | 1       | 1993-02-07 |
|  5 | Rama | 1       | 1994-12-09 |
+----+------+---------+------------+

need an explanation for this answer? contact us directly to get an explanation for this answer

total answers (1)

MySQL Exercises
This question belongs to these collections

Similar questions

need a help?

find thousands of online teachers now
Delete duplicate row from MySQL table... >>
<< Write a mysql statement to find the name, birth, d...