Horton

Re: [GENERAL] non-case sensitive searches

Kevin Heflin <kheflin@shreve.net>

View thread View on postgr.es
From: Kevin Heflin <kheflin@shreve.net>
To: Gilles Darold <darold@neptune.fr>
Cc: pgsql-general@postgreSQL.org
Date: 1999-01-13T14:39:29Z
Lists: 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
--------------------------------------------------------------------