From: Martin Ramsch Date: July 14 1999 6:59am Subject: Re: what's equiv to 'NOT IN' List-Archive: http://lists.mysql.com/mysql/7236 Message-Id: <19990714085926.B18108@forwiss.uni-passau.de> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii 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 PGP KeyID=0xE8EF4F75 FiPr=52 44 5E F3 B0 B1 38 26 E4 EC 80 58 7B 31 3A D7