See the FAQ item about index usage. You have to anchor the start only.
---
[EMAIL PROTECTED] wrote:
> > We require ~* syntax for that, or upper()/lower().
>
> Slowly the light dawns!
>
> If I anchor a ~ search on both end
> We require ~* syntax for that, or upper()/lower().
Slowly the light dawns!
If I anchor a ~ search on both ends, it is the same search as =.
Duh!
I converted the prototype over to use ~ and it is running much faster.
I'll try to do some detailed timings against MySQL tonight.
--
Mike Nolan
--
