【C400159】在MySQL中,查询所有姓名为“李**”三个字的学生信息,正确的选项是()。
A.SELECT StudentNo,StudentName FROM student WHERE StudentName
LIKE "李%%";
B.SELECT StudentNo,StudentName FROM student WHERE StudentName
= "李_";
C.SELECT StudentNo,StudentName FROM student WHERE StudentName
IN "李__";
D.SELECT StudentNo,StudentName FROM student WHERE StudentName
LIKE "李__";