数据表user表含有如下字段 id(int11 AUTO_INCREMENT),username(varchar20),password(varchar50),logins(int11) 在user表中检索出姓“张”的用户名,应该使用哪条语句实现
A、select * from user where username=’张’;
B、select username from user where username like ‘张’;
C、select username from user where username like ‘张%’;
D、select username from user where username like ‘%张%’;