Re: How to optimize this query?

[Yogesh Salvi]

Hello,

I think you should try following options:-

1. remove that 'UCASE' function from where clause, since mysql does match case insensetive.
2. try to avoid use of LIKE '%someword%'....means avoid use of %..% since such query require mysql to scan each row.
3. Try to use fulltext search instead of LIKE.


I think this should work for you.

Regards,
Yogesh Salvi