【2017Web前端面试题】表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 where title = 'cv' and type='1'

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

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

• D.select * from where title ='*cv*' and type='1