Postgres Pro
Downloads
Home   >   mailing lists

Re: [PHP] Case Insensitive Searching? - Mailing list pgsql-novice

From Kassel Ben S CRBE
Subject Re: [PHP] Case Insensitive Searching?
Date
Msg-id 72D610C9DC27D711A03A009027A8F40457C9B3@crbeex03.dt.navy.mil
Whole thread Raw
List pgsql-novice
Tree view 
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

pgsql-novice by date:

Previous
From: Nabil Sayegh
Date:
Subject: Re: add foreign key constraint after table creation?
Next
From: "Israel Calderon"
Date:
Subject: Double quoted column within CREATE TABLE statement