Re: [GENERAL] non-case sensitive searches

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(at)shreve(dot)net | Shreveport, LA 71101 | http://www.shreve.net
--------------------------------------------------------------------