SQL Interview Preparation—Intermediate Level/

...

/

Answer: Regular Expression

Answer: Regular Expression

Find a detailed explanation on how to use regular expressions to filter the records.

We'll cover the following...

Solution

The solution is given below:

MySQL
/* The query to find names with three consecutive vowels */
SELECT EName
FROM   Employees
WHERE  EName REGEXP '[AEIOU]{3}';

Code explanation

The explanation of the solution code is given below:

  • Lines 2–3: The SELECT statement selects the column EName. The data is retrieved from the Employees table.

  • Line 4: The WHERE clause specifies the condition on which we want to retrieve the data from the table. Here, we use the REGEXP operator to filter the names that contain three consecutive vowels.

Recalling relevant concepts

We have covered the following concepts in this question:

    ...