From: Ralph Graulich
Date: July 14 1999 7:14am
Subject: Re: what's equiv to 'NOT IN'
List-Archive: http://lists.mysql.com/mysql/7288
Message-Id: <l03130301b3b1e821da45@[192.168.77.77]>
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"

Hi Hawke,

>SHOW COLUMNS FROM GamerFinder WHERE Field NOT
>IN('ID','Email','PhoneNum');


You need to get through the logic of SQL, then it's easy. First make a
positive statement. Do it like this:

	[...] WHERE fieldname IN (set-definition)

As next step you negate the complete WHERE-clause, like this:

	[...] WHERE NOT (fieldname IN (set-definition))

For example:

SELECT horse,horse_country FROM dams WHERE NOT (horse_country IN("GB"))



Regards,
Ralph