Q. What will be the output of the following MySQL statement?
SELECT *
FROM employee
WHERE lname LIKE ‘F%’ OR lname LIKE ‘%T’;
SELECT *
FROM employee
WHERE lname LIKE ‘F%’ OR lname LIKE ‘%T’;
β
Correct Answer: (C)
All employees whose last name should started with 'F' and end with 'T'
Explanation: This question is asking about how to use the LIKE operator in MySQL to find employees with specific patterns in their last names. Let's break it down: