non-case sensitive searches

From: Kevin Heflin <kheflin(at)shreve(dot)net>
To: "PGSQL-General (E-mail)" <pgsql-general(at)postgreSQL(dot)org>
Subject: non-case sensitive searches
Date: 1999-01-13 07:41:03
Message-ID: Pine.LNX.4.02.9901130137020.21851-100000@mercury.shreve.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


Currently I have a select statement like so:

select * from photos where keywords LIKE '%$cat_name%'

The above select statement works, except that it is case sensitive.
Is there a way to do this that is not case sensitive?

Kevin

--------------------------------------------------------------------
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
--------------------------------------------------------------------

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Kevin Heflin 1999-01-13 07:52:31 Re: [GENERAL] non-case sensitive searches
Previous Message Dave Van Abel 1999-01-13 00:04:44 Web-Based Reports (cgi using mod_perl)