Q. What will be the output of the following MySQL statement?
SELECT *
FROM employee
WHERE lname LIKE %bas% OR fname LIKE %bbs%;

  • (A) All employees whose last name should contain substring "bas"
  • (B) All employees whose first name should contain substring "bbs"
  • (C) All employees whose last name should contain substring "bas" or first name should contain substring "bbs"
  • (D) None of the mentioned
πŸ’¬ Discuss
βœ… 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.
Explanation by: Admin
This question is about how to use the LIKE operator with wildcards in MySQL to find specific data.

πŸ’¬ Discussion


πŸ“Š Question Analytics

πŸ‘οΈ
72
Total Visits
πŸ“½οΈ
1 y ago
Published
πŸŽ–οΈ
Admin
Publisher
πŸ“ˆ
82%
Success Rate