"Not like" operation does not use index.

select * from vtiger_contactscf where lower(cf_1253) not like
lower('Former%')

I created index on lower(cf_1253).

How can I ensure index usage in not like operation?
Anyone please help.

Reply via email to