Antw: [SQL] Partial Search

From: "Gerhard Dieringer" <DieringG(at)eba-haus(dot)de>
To: <pez(at)aiming(dot)net>, <pgsql-sql(at)postgresql(dot)org>
Subject: Antw: [SQL] Partial Search
Date: 1999-12-01 14:50:09
Message-ID: s84543c0.056@kopo001
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql


>>> <pez(at)aiming(dot)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

Browse pgsql-sql by date

  From Date Subject
Next Message Virgilio Sanz 1999-12-01 16:04:23 do queries from strings in pgplsql
Previous Message pez 1999-12-01 14:07:48 Partial Search