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