单项选择题

要查询Information表中学生姓中含有“张”的学生情况,可以用下列哪个命令______

A) SELECT*FROM Information WHERE s_name=’张’
B) SELECT*FROM Information WHERE s_name LIKE’张%’
C) SELECT*FROM Information WHERE s_name LIKE’张’
D) SELECT*FROM Information WHERE s_name LIKE’%张%’