要查询INFORMATION表中姓“王”且日￡名的学生情况。可以用下列哪个命令?…

A．SELECT*FROM INFORMATION WHERE姓名=‘王--’

B．SELECT*FROM INFORMATION WHERE姓名LIKE‘王％’

C．SELECT*FROM INFORMATION WHERE姓名=‘王％’

D．SELECT*FROM INFORMATION WHERE姓名LIKE‘王_’