Received: from bashir.belgium.eu.net (bashir.Belgium.EU.net [193.74.208.147])
	by hub.org (8.9.3/8.9.3) with ESMTP id MAA69150
	for <pgsql-sql@postgreSQL.org>; Wed, 1 Dec 1999 12:00:54 -0500 (EST)
	(envelope-from wim.ceulemans@nice.be)
Received: from (IDENT:0@idialup495.brussels2.eunet.be [193.75.159.240])
	by bashir.belgium.eu.net  with ESMTP id SAA06053;
	Wed, 1 Dec 1999 18:00:47 +0100 (MET)
Received: from nice.be (aladdin.nice.be [192.168.250.110])
	by uni-box.nice.be (8.9.1/8.9.1) with ESMTP id RAA06063;
	Wed, 1 Dec 1999 17:58:29 +0100
Message-ID: <384554CF.924BF895@nice.be>
Date: Wed, 01 Dec 1999 18:03:11 +0100
From: Wim Ceulemans <wim.ceulemans@nice.be>
X-Mailer: Mozilla 4.7 [en] (Win95; I)
X-Accept-Language: en
MIME-Version: 1.0
To: pez@aiming.net
CC: pgsql-sql@postgreSQL.org
Subject: Re: [SQL] Partial Search
References: <38452BB4.B7F32589@aiming.net>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

pez@aiming.net wrote:
> 
> I am trying to do a query with a partial search but don't know the
> syntax.  eg. I want the word 'buff' to find 'buffalo' in the variable
> 'city'.  Can anyone give me an example?
> 

select * from table where city like '%buff%';

or case insensitive:

select * from table where city ~* 'buff';