单选题

查询title中包含cv且type是1的记录

Question

表toutiao_tb

title   data       auther  type

abc     2016.2.23   bob     1

bcv     2016.3.3    http    1

cvt     2016.3.3    http    1

bcvvcm  2016.3.5    js      2

nmhh    2016.2.3    html    2

hhj     2016.3.3    java    3

rrr     2016.3.2    cc      1

查询title中包含cv且type是1的记录

A. select * from toutiao_tb where title = 'cv' and type='1'

B. select * from toutiao_tb where title like '%cv%' and type=1

C. select * from toutiao_tb where title like '*cv' and type=1

D. select * from toutiao_tb where title ='*cv*' and type='1&lsquo