Searching Text Fields - Case Sensitive?

From: "Mike Field" <mike(at)fieldco(dot)com>
To: <pgsql-sql(at)postgreSQL(dot)org>
Subject: Searching Text Fields - Case Sensitive?
Date: 1999-08-12 14:59:20
Message-ID: 003401bee4d3$42774e20$0200a8c0@mike
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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?

Please let me know.
Thanks,
Mike

mike(at)fieldco(dot)com

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Emils Klotins 1999-08-12 15:20:00 Re: [SQL] Problem with postgreSQL triggers
Previous Message Tom Lane 1999-08-12 14:34:21 Re: [SQL] quest:optimization with indexes