Return-Path: postman
Received: from localhost.Berkeley.EDU (localhost.Berkeley.EDU [127.0.0.1]) by nobozo.CS.Berkeley.EDU (8.6.10/8.6.3) with SMTP id HAA14376 for postgres-redist; Wed, 28 Jun 1995 07:59:24 -0700
Resent-From: POSTGRES mailing list <postman@postgres.Berkeley.EDU>
Resent-Message-Id: <199506281459.HAA14376@nobozo.CS.Berkeley.EDU>
X-Authentication-Warning: nobozo.CS.Berkeley.EDU: Host localhost.Berkeley.EDU didn't use HELO protocol
Sender: owner-postman@postgres.Berkeley.EDU
X-Return-Path: owner-postman
Received: from flowbee.interaccess.com (matthew@flowbee.interaccess.com [198.80.0.32]) by nobozo.CS.Berkeley.EDU (8.6.10/8.6.3) with ESMTP id HAA14366 for <postgres@postgres.berkeley.edu>; Wed, 28 Jun 1995 07:59:23 -0700
Received: (matthew@localhost) by flowbee.interaccess.com (8.6.12/8.6.10) id JAA14396 for postgres@postgres.berkeley.edu; Wed, 28 Jun 1995 09:54:40 -0500
From: "matthew@risetime.com" <matthew@interaccess.com>
Message-Id: <199506281454.JAA14396@flowbee.interaccess.com>
Subject: trouble with "like" clause
To: postgres@postgres.Berkeley.EDU (postgres)
Date: Wed, 28 Jun 1995 09:54:39 -0500 (CDT)
Reply-To: matthew@interaccess.com
X-URL: http://www.interaccess.com/matthew
X-Mailer: ELM [version 2.4 PL23]
Content-Type: text
Content-Length: 728       
Resent-To: postgres-redist@postgres.Berkeley.EDU
Resent-Date: Wed, 28 Jun 95 07:59:24 -0700
Resent-XMts: smtp

I want to be able to do a substring case-insensitive search on a text field.

So far I have:
	SELECT * from Movies WHERE MovieName ~ "[Bb][Aa][Tt]*"

Which will make macthes with "Batman Forever".  If I instead enter in
"Forever" I should also make a matche, however, change the where clause to
"*[Ff][Oo][Rr][Ee][Vv][Ee][Rr]" failes to find a match.

What the correct syntax for that?

- mz

----
matthew zeier                     "Do what you can with what you have
  matthew@risetime.com             where you are."  -Teddy Roosevelt
......................................................................
Programmer / Online Junkie                        Ph. 708/483-8787
  "So no one told you like was gonna be this way..."

==============================================================================
   To add/remove yourself to/from the POSTGRES mailing list: send mail with 
   the subject line ADD or DEL to "postgres-request@postgres.Berkeley.EDU".
   If this fails, send mail to "post_questions@postgres.Berkeley.EDU" and
   a human will deal with it.  DO NOT post to the "postgres" mailing list.
==============================================================================
              URL: http://s2k-ftp.CS.Berkeley.EDU:8000/postgres/