Q. What will be the output of the following MySQL statement?
SELECT *
FROM employee
WHERE lname LIKE %bas% OR fname LIKE %bbs%;
β
Correct Answer: (C)
All employees whose last name should contain substring "bas" or first name should contain substring "bbs"
Explanation: This question is about how to use the LIKE operator with wildcards in MySQL to find specific data.