It's not possible in the query, but I wonder if there's a UDF you could write that takes in the name of a table, and then a list of columns NOT to show, and outputs a string of comma-separated values.
That'd be neat, so then you could write: SELECT allBut(mytable,badfield1,badfield2,. . .) FROM mytable; Would that even work? Is the query done first, and then the UDF performed? (my apologies for throwing out an idea that may or may not work). -Sheeri On 12/9/05, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > Frank Rust <[EMAIL PROTECTED]> wrote on 12/09/2005 01:59:35 AM: > > > Is there a possibility to select all columns from a table except one or > > two columns? For example I have a table with 30 columns and want all > > columns but one column *not*. Do I have to write a very long select > > statement with 29 column names that i want to get? > > > > -- > > ________________________________________________________________________ > > Frank Rust, Technische Universität, Institut für Theoretische Informatik > > Tel.: +49 531 391 9525 Postfach 3329, D-38023 Braunschweig > > Fax.: +49 531 391 9529 Mühlenpfordtstr. 22-23, D-38106 Braunschweig > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]