Simple Question: Case sensitivity - Mailing list pgsql-general

From Abe
Subject Simple Question: Case sensitivity
Date
Msg-id 006501c062a4$07ccba30$6500a8c0@win2k
Whole thread Raw
In response to Problems with Mandrake RPM  (John Pilley <jpilley@spescrow.com>)
Responses Re: Simple Question: Case sensitivity
List pgsql-general
This is probably an easy question for most but here goes:

I am using PHP3 and postgres 6.5

I am trying to do a search on a peoples database and it works fine except
for the fact that I want to make it case insensitive as some in the database
are Smith and some are jones.  Is this a scripting thing or can it be done
in my query.

Here is the query:

$sql = "select surname, firstname, title, company, worktel, ext, hometel,
mobile, email, emailtwo from employees where firstname like '%$criteria%' or
surname like '%$criteria%'";

Thanks in advance,
Abe


pgsql-general by date:

Previous
From: Ashley Clark
Date:
Subject: Re: why doesn't this work?
Next
From: "Hancock, David (DHANCOCK)"
Date:
Subject: RE: Simple Question: Case sensitivity