This quiz will test your understanding of wildcards and regular expressions in MySQL. You’ll encounter questions on the LIKE and REGEXP operators, how to use wildcards like % and _ for flexible searches, and how regular expressions enable advanced pattern matching. These techniques are essential for searching and manipulating text data efficiently in MySQL.
1.
What does [[:alnum:]] match in a MySQL regular expression?
2.
Which regular expression pattern ensures that a word appears as a separate word in a string?
3.
What will the following query return?
SELECT name FROM product WHERE name LIKE 'Mac%';
4.
Which MySQL function is used to replace occurrences of a pattern using regular expressions?
5.
Which wildcard character matches exactly one character in a LIKE query?
6.
What does the . (dot) symbol represent in a MySQL regular expression?
7.
Which operator is used for regular expression matching in MySQL?
8.
Which wildcard should be used to find a name that starts with 'Book'?
9.
Which SQL statement would retrieve all rows where the product name ends with 'Pro'?
10.
Which wildcard should be used in a LIKE statement to find names that contain 'Air' anywhere in the string?
11.
What does [[:digit:]]{3} match in a MySQL regular expression?
12.
Which regular expression pattern ensures that a word appears at the beginning of a string?
13.
What does the wildcard character % represent in a MySQL LIKE query?
14.
Which SQL clause is used in MySQL for wildcard pattern matching?
15.
Which regular expression pattern would match a product name that contains 'USB' followed by either 'A' or 'C'?
16.
Which MySQL function is used to search for a pattern in a string using regular expressions?
