> > >

MySQL MCQs

Which of the following is correct syntax for selecting all rows from a table 'PERSONS', with strings in the column 'LASTNAME' starting with 'JOH'?

SELECT * from PERSONS where LASTNAME LIKE 'JOH%';

SELECT * from PERSONS where LASTNAME IS LIKE 'JOH%';

SELECT * from PERSONS where LASTNAME LIKE 'JOH*';

SELECT * from PERSONS where LASTNAME IS LIKE 'JOH*';

Answer

Correct Answer: SELECT * from PERSONS where LASTNAME LIKE 'JOH%';

Explanation:

Note: This Question is unanswered, help us to find answer for this one

MySQL Skill Assessment

Your Skill Level: Poor

Retake Quizzes to improve it