Thread: RE: [GENERAL] non-case sensitive searches

RE: [GENERAL] non-case sensitive searches

From
"Jackson, DeJuan"
Date:
> On Wed, 13 Jan 1999, Jackson, DeJuan wrote:
>
> > And remember unless you use full text indexing (which is
> expensive) you
> > won't have indexing on that search (for either the LIKE or regex).
> >     -DEJ
>
> Actually, if you use case sensitive regex, and anchor the
> begining (with
> ^) then it will use btree indexes.

So will a front anchored LIKE, but the query that was being performed
was an unanchored LIKE (i.e. '%stuff%').