Search⌘ K
AI Features
Home
Courses
SQL Interview Preparation—Intermediate Level

Answer: Regular Expression

Explore how to apply regular expressions and pattern matching in SQL to filter employee names with specific vowel sequences. Understand the use of REGEXP, LIKE, CONCAT, and REGEXP_LIKE functions through examples and practice with related interview questions.

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. ...