like 与 instr哪个效率更高一些呢？

explain SELECT c.cpny_id,c.csf_cd,l.cpny_nm 
FROM fdp.company c , fdp.company_lang l  
WHERE c.cpny_id=l.cpny_id and l.lang_cd='EN' AND INSTR(l.cpny_nm,'shanghai')>0;

explain SELECT c.cpny_id,c.csf_cd,l.cpny_nm 
FROM fdp.company c , fdp.company_lang l  
WHERE c.cpny_id=l.cpny_id and l.lang_cd='EN' AND l.cpny_nm like '%shanghai%'>0;


两者的执行计划一模一样，想问下，大家在实际中，用instr多一些还是like多一些啊？

like多一些
l.cpny_nm like 'shanghai%'：这种形式可以用到索引