183
183
1 SIMPLE t2 range fld1 fld1 4 NULL # Using where; Using index
184
184
select fld1,fld3 from t2 where companynr = 37 and fld3 like 'f%';
217
217
select fld3 from t2 where fld3 like "L%" and fld3 = "ok";
219
219
select fld3 from t2 where (fld3 like "C%" and fld3 = "Chantilly");