A

Admin • 833K Points
Coach

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

  • (A) All employees whose last name should started with 'F' and end with 'T'
  • (B) All employees whose last name start with 'T' and end with 'F'
  • (C) All employees whose last name should started with 'F' and end with 'F'
  • (D) None of the mentioned
  • Correct Answer - Option(A)
  • Views: 32
  • Filed under category MySQL
  • Hashtags:

Explanation by: Admin

This question asks about how the LIKE operator works in MySQL. Let's break down the code:

You must be Logged in to update hint/solution

Discusssion

Login to discuss.

Be the first to start discuss.