当起始不是模糊查询时,其实是可以用索引的
explain extended select * from users where email like '303578599%'
explain extended select * from users where email like '303%578599%'
如果起始就是模糊查询,就要全表扫描了
explain extended select * from users where email like '%303578599%'