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
