From: Date: July 30 1999 5:54pm
Subject: Re: what's equiv to 'NOT IN'
List-Archive: http://lists.mysql.com/mysql/8881
Message-Id: <14241.51828.883576.132165@monty.pp.sci.fi>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

>>>>> "Martin" == Martin Ramsch <m.ramsch@stripped> writes:

Martin> On Tuesday, 1999-07-13 22:25:41 -0600, Hawke Robinson wrote:
>> SHOW COLUMNS FROM GamerFinder WHERE Field NOT
>> IN('ID','Email','PhoneNum');
>> I also tried:
>> SHOW COLUMNS FROM GamerFinder WHERE Field != 'ID';

Martin> The SHOW command doesn't understand WHERE.  Just look in the manual
Martin> what the exact syntax of SHOW is; everything _not_ mentioned there
Martin> isn't possible either.

Martin> So--as far as I see--it's not possible to SHOW all except one columns.
Martin> You will have to filter the data on the application side ...

Martin> Regards,
Martin>   Martin

Some day we will add a 'catalog database' interface in addition to the 
SHOW commands. With this, you will be able to search on anything.

Regards,
Monty