单项选择题

对于学生信息表:student(sno,sname,sex,age,dept),要查询所有刘姓学生的信息,正确的语句是

A.SELECT * FROM student WHERE sname LIKE'刘 * '
B.SELECT * FROM student WHERE sname LIKE'刘 $'
C.SELECT * FROM student WHERE sname LIKE'刘%'
D.SELECT * FROM student WHERE sname LIKE'刘&'