在MySQL中，要从表"PERSONS"中选择"LASTNAME"列中以"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*';
