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

On Wed, 13 Jan 1999, Gilles Darold wrote:

> Hi Kevin,
>
> 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..

WHERE keywords ~* '.*$cat_name.*';

or

WHERE lower(keywords) LIKE lower('%$cat_name%')


Thanks again.


--------------------------------------------------------------------
Kevin Heflin          | ShreveNet, Inc.      | Ph:318.222.2638 x103
VP/Mac Tech           | 333 Texas St #619    | FAX:318.221.6612
kheflin@shreve.net    | Shreveport, LA 71101 | http://www.shreve.net
--------------------------------------------------------------------