List:General Discussion« Previous MessageNext Message »
From:Martin Ramsch Date:July 14 1999 6:59am
Subject:Re: what's equiv to 'NOT IN'
View as plain text  
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';

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

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

Regards,
  Martin
-- 
Martin Ramsch <m.ramsch@stripped> <URL: http://home.pages.de/~ramsch/ >
PGP KeyID=0xE8EF4F75 FiPr=52 44 5E F3 B0 B1 38 26  E4 EC 80 58 7B 31 3A D7
Thread
what's equiv to 'NOT IN'Hawke Robinson14 Jul
  • Re: what's equiv to 'NOT IN'Martin Ramsch14 Jul
    • Re: what's equiv to 'NOT IN'Michael Widenius30 Jul
  • what's equiv to 'NOT IN'sinisa14 Jul
  • Re: what's equiv to 'NOT IN'Ralph Graulich14 Jul