>>>>> "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
