Re: [PHP] Case Insensitive Searching?

From: Kassel Ben S CRBE <KasselB(at)nswccd(dot)navy(dot)mil>
To: "'pgsql-novice(at)postgresql(dot)org '" <pgsql-novice(at)postgresql(dot)org>
Subject: Re: [PHP] Case Insensitive Searching?
Date: 2003-05-27 02:25:43
Message-ID: 72D610C9DC27D711A03A009027A8F40457C9B3@crbeex03.dt.navy.mil
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

PostgreSQL regular expression :

SELECT * FROM TABLE WHERE SOMETHING ~* 'MiXeD CaSe';

~* is the regular expression operator for ignore case.

Check out http://techdocs.postgresql.org/guides/RegularExpressionIntro

Browse pgsql-novice by date

  From Date Subject
Next Message Israel Calderon 2003-05-27 02:31:38 Double quoted column within CREATE TABLE statement
Previous Message Israel Calderon 2003-05-27 01:32:08 Creation of Redundant Tables.