Postgres Pro
Downloads
Home   >   mailing lists

Like and Not LIke - Mailing list pgsql-novice

From richard terry
Subject Like and Not LIke
Date
Msg-id 201010091345.36070.rterry@pacific.net.au
Whole thread Raw
Responses Re: Like and Not LIke  (Andrej <andrej.groups@gmail.com>)
List pgsql-novice
Tree view 
Hi List,

I need a simple query which incorporates this sort of logic.

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.

Any help appreciated.

Regards

Richard

pgsql-novice by date:

Previous
From: Mark Kelly
Date:
Subject: Re: MySQL --> PostgreSQL with PHP
Next
From: Andrej
Date:
Subject: Re: Like and Not LIke