SELECT S#,SNAME FROM S WHERE SNAME=’李%’ SELECT S#,SNAME FROM S WHERE SNAME LIKE’李%’ SELECT S#,SNAME FROM S WHERE SNAME=’%李%’ SELECT S#,SNAME FROM S WHERE SNAME LIKE’%李%’
SELECT S#,SNAME FROM S WHERE SNAME=’李%’ SELECT S#,SNAME FROM S WHERE SNAME LIKE’李%’ SELECT S#,SNAME FROM S WHERE SNAME=’%李%’ SELECT S#,SNAME FROM S WHERE SNAME LIKE’%李%’