Home » MCQs » MySQL MCQs

What will the following statement return? Where student_details is the table name and student_name is the column name?

29. What will the following statement return?

SELECT * FROM student_details WHERE Student_name LIKE 'S%';

Where student_details is the table name and student_name is the column name?

1. It will return the name starting with s
2. It will return the name ending with s
3. It will return the name who has s in between

Answer: A) It will return the name starting with s

Explanation:

The statement will return the name starting with s