like要用到索引必须满足2个条件:该字段有索引、%在后面 select * from prod_main where prod_name like 'python%' limit 20; prod_name字段要有索引