V

Vijay Sangwan • 28.62K Points
Instructor II

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

(A) All employees whose last name should started with 'F'
(B) All employees whose last name end with 'T'
(C) All employees whose last name should started with 'F' and end with 'T'
(D) None of the mentioned

Correct Answer - Option(C)
Views: 14
Filed under category MySQL

Explanation by: Vijay Sangwan

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:

You must be Logged in to update hint/solution

Discusssion

Login to discuss.

Question analytics