Skip site navigation (1) Skip section navigation (2)

Re: [PHP] Case Insensitive Searching?

From: Bruno Wolff III <bruno(at)wolff(dot)to>
To: Ben Schneider <bcschnei(at)attbi(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org, pgsql-php(at)postgresql(dot)org
Subject: Re: [PHP] Case Insensitive Searching?
Date: 2003-05-25 13:56:30
Message-ID: 20030525135630.GB1057@wolff.to (view raw or flat)
Thread:
Lists: pgsql-novicepgsql-php
On Fri, May 23, 2003 at 13:24:36 -0700,
  Ben Schneider <bcschnei(at)attbi(dot)com> wrote:
> 
> So the question is, how do I perform a case insensitive search? Is there a
> DB setting I can set to ignore the case?

If you were using "like", you can use "ilike" instead. There is also
a case insensitive version of the regular expression pattern matching
operator. In some cases you may want to use the "lower" function
to get the data in just one case before doing a comparison. Without
seeing how you are doing your searches now it is hard to provide
specifics on what to do to make them case insensitive.

In response to

pgsql-novice by date

Next:From: Nabil SayeghDate: 2003-05-25 16:34:38
Subject: Example Re: SELECT across multiple db
Previous:From: John K. HerreshoffDate: 2003-05-25 13:13:02
Subject: Using SSL on VB5 Apps

pgsql-php by date

Next:From: Ernest E VogelsingerDate: 2003-05-25 19:51:22
Subject: Re: [PHP] Case Insensitive Searching?
Previous:From: Frank BaxDate: 2003-05-25 02:01:30
Subject: Re: faster output from php and postgres

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group