试题详情

SQL语句,使用like进行模糊查询时, 以下 会导致全表 扫描。

Aselect * from table_1 where username like ‘%yue%’

Bselect * from table_1 where username like ‘yue%’

Cselect * from table_1 where username like ‘wang%’

Dselect * from table_1 where username like ‘li%’