Home > mailing lists

Re: Like and Not LIke - Mailing list pgsql-novice

From	Andrej
Subject	Re: Like and Not LIke
Date	October 9, 2010 04:55:34
Msg-id	AANLkTi=Xq7QnSXhCH5jMURvGTNhwaCOycWXV5+XaGDEm@mail.gmail.com Whole thread Raw
In response to	Like and Not LIke (richard terry <rterry@pacific.net.au>)
List	pgsql-novice

Tree view

On 9 October 2010 15:45, richard terry <rterry@pacific.net.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%'
?

pgsql-novice by date:

From: richard terry
Date: 09 October 2010, 02:45:47
Subject: Like and Not LIke

From: e-letter
Date: 09 October 2010, 07:41:23
Subject: permissions failure to copy csv data

Re: Like and Not LIke - Mailing list pgsql-novice

Previous

Next