Horton

Antw: [SQL] Partial Search

Gerhard Dieringer <dieringg@eba-haus.de>

View thread View on postgr.es
From: "Gerhard Dieringer" <DieringG@eba-haus.de>
To: <pez@aiming.net>, <pgsql-sql@postgresql.org>
Date: 1999-12-01T14:50:09Z
Lists: pgsql-sql 
>>> <pez@aiming.net> 01.12.1999  15.07 Uhr >>>
>> 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?
>>
>>--
>>Cheers,
>>
>>Derek

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

-------------------
Gerhard