What will be the output of the following query?SELECT stu

Home » MYSQL » Mysql miscellaneous » Question

What will be the output of the following query?

SELECT stu_id, first_name, last_name
FROM student
WHERE LEFT (first_name, 1) =’F’ OR LEFT (last_name, 1) =’F’;

1. Only those student are selected whose first name and last name started with any other letter except ‘F’
2. Only those student are selected whose first name and last name started with ‘F’
3. Only those student are selected whose first name started with ‘F’ but last name can be starts with any other letter
4. All of above
5. None of these

Only those student are selected whose first name and last name started with ‘F’