Home » MCQs » MySQL MCQs

Suppose you are asked to display all the names which have 'a' as their second character then which query pattern you will use?

30. Suppose you are asked to display all the names which have 'a' as their second character then which query pattern you will use?

1. _ _ a%;
2. _a_;
3. _a%;
4. _%a;

Answer: C) _a%;

Explanation:

To know the name who has an as its second character we will write: _a%;