Subject Re: another make my query faster question
Author Adam
--- In, "markd_mms" <spam@...> wrote:
> --- In, "markd_mms" <spam@> wrote:
> > i tried different conditions like =, LIKE, CONTAINING but it didn't
> > seem to make a difference.
> although i just tried STARTS WITH and it doesn't seem to slow the
> query down.
> mark

Two questions:

1) Why do you need the OR condition?

If anything is guaranteed to match a soundex, it is an identical
string. Just seems like extra work with no benefit to me.

2) How would it be possible to use an index on title to solve
a 'containing' or 'like' query?

Although I am surprised you did not have more luck with '='.