No it's not possible but you can just read in all tables anyway and ignore
the columns you don't want.

----- Original Message -----
From: "David Jacobowitz" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, February 27, 2001 7:33
Subject: Need help with select statement.


> Dear Sir,
>
> I have looked in the manual but could not find any clue so I am seeking
your
> assistance. I have a table with 25 fields and I use most of these fields
but
> not all in different DBI scripts. Currently I use:
>
> SELECT field_1, field_4, ...getting tired typing field names... FROM
myTest;
>
> Is it possible to do something like:
> SELECT * FROM myTest EXCEPT field_2, field_3;
>
> Greatly appreciate your help.
>
> David
>
> _________________________________________________________________
> Get your FREE download of MSN Explorer at http://explorer.msn.com
>
>
> ---------------------------------------------------------------------
> Before posting, please check:
>    http://www.mysql.com/manual.php   (the manual)
>    http://lists.mysql.com/           (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
<[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php


---------------------------------------------------------------------
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Reply via email to