Home » MCQs » MariaDB MCQs

Which is the correct MariaDB query to get the list of products starting with a vowel?

38. Which is the correct MariaDB query to get the list of products starting with a vowel?

1. SELECT product_name FROM products WHERE product_name REGEXP '^[aeiou]';
2. SELECT product_name FROM products WHERE product_name REGEXP '^aeiou';
3. SELECT product_name FROM products WHERE product_name REGEXP '*[aeiou]*';
4. None of the above

Answer: A) SELECT product_name FROM products WHERE product_name REGEXP '^[aeiou]';

Explanation:

The correct MariaDB query to get the list of products starting with a vowel is:

Syntax:

SELECT product_name FROM products WHERE product_name REGEXP '^[aeiou]';