Re: [SQL] Partial Search - Mailing list pgsql-sql

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';