Home » MYSQL » Mysql miscellaneous » Question
  1. What will be the output of the following query?
    SELECT *
    FROM student
    WHERE last_name LIKE %bas% OR first_name LIKE %bbs%;
    1. All student whose last name should contain substring “bas” or first name should contain substring “bbs”
    2. All student whose last name should contain substring “bas”
    3. All student whose first name should contain substring “bbs”
    4. All of above
    5. None of these
Correct Option: A

All student whose last name should contain substring “bas” or first name should contain substring “bbs”



Your comments will be displayed only after manual approval.