Re: Like and Not LIke

From: Andrej <andrej(dot)groups(at)gmail(dot)com>
To: richard terry <rterry(at)pacific(dot)net(dot)au>
Cc: PostgreSQL - newbie <pgsql-novice(at)postgresql(dot)org>
Subject: Re: Like and Not LIke
Date: 2010-10-09 04:55:23
Message-ID: AANLkTi=Xq7QnSXhCH5jMURvGTNhwaCOycWXV5+XaGDEm@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

On 9 October 2010 15:45, richard terry <rterry(at)pacific(dot)net(dot)au> wrote:
> Filename is like filter1 but not like filter 2
>
> Its easy enough to do Filename ILIKE '%filter1%, but I've not been able to find
> the syntax to complete the logic.
Filename ILIKE '%filter1%' AND Filename NOT ILIKE '%filter2%'
?

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message e-letter 2010-10-09 07:41:14 permissions failure to copy csv data
Previous Message richard terry 2010-10-09 02:45:36 Like and Not LIke