[Koha-devel] query optimization

[paul POULAIN]

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