[Koha-devel] query optimization

Many queries are build with : (title like '$key[0]%' or title like '% $key[0]%') I was wondering why : * title like '$key%' is index optimizable * title like '% $key%' is NOT index optimizable. optimizable OR not optimizable === NOT optimizable. So the resulting query is not optimizable. So, what's the interest of such a string, as "title like '%'.$key.'%'" has the same result ? -- Paul