SELECT all except ... ?

[Frank Rust <suppressed>]

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/suppressed