Home » MCQs » SQL MCQs » SQL Pattern Matching MCQs

What does the following statement do (1)?

7. What does the following statement do?

WHERE CustomerName LIKE '%a'

1. Finds any values that end with "a"
2. Finds any values whose second character is "a"
3. Find any values that contains only two characters ending with "a"
4. Mysql > Savepoint ini;

Answer: A) Finds any values that end with "a"

Explanation:

The above statement finds any values that end with "a"