student表的studentName字段有索引，下列SQL中索引不会失效，能够正确使用的是？

student表的studentName字段有索引，下列SQL中索引不会失效，能够正确使用的是？

A.SELECT studentName FROM student WHERE studentName like "%李";

B.SELECT studentName FROM student WHERE studentName like "李%";

C.SELECT studentName FROM student WHERE studentName like "%

D.SELECT studentName FROM student WHERE studentName like "%李%";

正确答案是B