Home > mailing lists

Searching Text Fields - Case Sensitive? - Mailing list pgsql-sql

From	Mike Field
Subject	Searching Text Fields - Case Sensitive?
Date	August 12, 1999 13:55:24
Msg-id	003401bee4d3$42774e20$0200a8c0@mike Whole thread Raw
List	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

From: Tom Lane
Date: 12 August 1999, 13:36:23
Subject: Re: [SQL] quest:optimization with indexes

From: Bart Ogryczak
Date: 12 August 1999, 14:24:24
Subject: Re: [SQL] Searching Text Fields - Case Sensitive?