Postgres Pro
Downloads
Home   >   mailing lists

Re: [SQL] Searching Text Fields - Case Sensitive? - Mailing list pgsql-sql

From Bart Ogryczak
Subject Re: [SQL] Searching Text Fields - Case Sensitive?
Date
Msg-id 37B2E714.DB904C2B@bart.w-wa.pl
Whole thread Raw
In response to Searching Text Fields - Case Sensitive?  ("Mike Field" <mike@fieldco.com>)
List pgsql-sql
Tree view 
> Mike Field wrote:
> Hi-
> If I want to search a text field for a certain word, say 'foobar',
> using:
> SELECT * FROM mydb WHERE description LIKE "%foobar%";
> it seems to be case sensitive.  Is there a way to do it so it is NOT
> case-sensitive?
SELECT * FROM mydb WHERE lower(description) LIKE "%foobar%";

bart
-- 
bart@bart.w-wa.pl || http://www.bart.w-wa.pl

pgsql-sql by date:

Previous
From: "Mike Field"
Date:
Subject: Searching Text Fields - Case Sensitive?
Next
From: "Frank Morton"
Date:
Subject: Select Maximum Question