对于学生信息表：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'刘&'