Like and Not LIke

From: richard terry <rterry(at)pacific(dot)net(dot)au>
To: "PostgreSQL - newbie" <pgsql-novice(at)postgresql(dot)org>
Subject: Like and Not LIke
Date: 2010-10-09 02:45:36
Message-ID: 201010091345.36070.rterry@pacific.net.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

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

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Andrej 2010-10-09 04:55:23 Re: Like and Not LIke
Previous Message Mark Kelly 2010-10-08 22:47:06 Re: MySQL --> PostgreSQL with PHP