Re: [GENERAL] non-case sensitive searches - Mailing list pgsql-general

> > You can also use regexp expression like this :
> >
> >     SELECT * FROM photos WHERE keywords ~* '.*$cat_name.*';
> >
> > it works fine.
>
>
> Thanks for the tip. Any recommendations as to which would be faster when
> searching about 2,000 records or so..

LIKE is faster, but with 2,000 records, you won't be able to tell the
difference. It takes a blink.

--Gene