Q. What will be the output of the following MySQL statement?
SELECT *
FROM employee
WHERE lname LIKE ‘F%’ AND lname LIKE ‘%T’;
SELECT *
FROM employee
WHERE lname LIKE ‘F%’ AND lname LIKE ‘%T’;
✅ Correct Answer: (A)
All employees whose last name should started with 'F' and end with 'T'
Explanation: This question asks about how the LIKE operator works in MySQL. Let's break down the code: