> >LIKE can use indexes, ~* can not, that's LIKE's main advantage (at least
in
> >my opinion).
> >
>
> ~ does use indexes, ~* doesnt,
> but then nor does the equivalent upper(columnname) LIKE 'TERM'. Make sure
> you're comparing apples with apples.
Indeed, all that's true but did I say otherwise? What I said was true, just
not as detailed as yours.. Apples to apples though, the origional poster
just wanted to search for substrings and said nothing about case.
No big deal, just clearing that up.
-Mitch