Received: from ubik.melog.com.pl (IDENT:qmailr@ubik.melog.com.pl [212.160.91.66]) by hub.org (8.9.3/8.9.3) with SMTP id LAA28067 for ; Thu, 12 Aug 1999 11:23:27 -0400 (EDT) (envelope-from bart@bart.w-wa.pl) Received: (qmail 20819 invoked from network); 12 Aug 1999 15:24:06 -0000 Received: from localhost (HELO bart.w-wa.pl) (bart@127.0.0.1) by localhost with SMTP; 12 Aug 1999 15:24:06 -0000 Sender: bart Message-ID: <37B2E714.DB904C2B@bart.w-wa.pl> Date: Thu, 12 Aug 1999 17:24:05 +0200 From: Bart Ogryczak Organization: Covert X-Mailer: Mozilla 4.6 [en] (X11; U; Linux 2.2.9 i586) X-Accept-Language: en MIME-Version: 1.0 To: pgsql-sql@postgreSQL.org Subject: Re: [SQL] Searching Text Fields - Case Sensitive? References: <003401bee4d3$42774e20$0200a8c0@mike> Content-Type: text/plain; charset=iso-8859-2 Content-Transfer-Encoding: 7bit > 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