A

Admin • 833.24K Points
Coach

Q. What will be the output of the following MySQL statement?
SELECT *
FROM employee
WHERE lname LIKE ‘_a%e%’;

  • (A) All employees whose last name start with any letter but second letter should be 'a'
  • (B) All employees whose last name start with any letter but contain at least one 'e' in his name
  • (C) All employees whose last name should have letter 'a' in second position and at least one 'e' in his name
  • (D) All of the mentioned
  • Correct Answer - Option(D)
  • Views: 27
  • Filed under category MySQL
  • Hashtags:

Explanation by: Admin

This question is about using the LIKE operator in MySQL to filter data based on patterns in a column. Here's a breakdown of the code and the options:

You must be Logged in to update hint/solution

Discusssion

Login to discuss.

Be the first to start discuss.