Select * except 3 1

[aalnaif]

I want to select all columns from a table, EXCEPT three, which are called "id", "name", and "active".

I can't simply tell MySQL to select all the other columns, because I do not know beforehand how many columns there will be, or what they will be called.

Is there something like this that I can do?
> SELECT * EXCEPT id, name, active FROM table

 

[sleipnir214]

To the best of my knowledge, you can't do that in a single query.

It is possible to issue a [tt]DESCRIBE tablename[/tt] query and use a programming language to process the return of that query to get all the columns and dynamically create the [tt]SELECT[/tt] query you need.



Want the best answers? Ask the best questions! TANSTAAFL!

 

[r937]

I do not know beforehand how many columns there will be, or what they will be called"

what kind of an app are you building?

and if you don't know what columns the table has, how do you know that it will have exactly those three that you are trying to avoid?

r937.com | rudy.ca

 

[aalnaif]

It's just that I'm writing a stored procedure that is manipulating a table. And since I'm working on contract for this company, I want to make the stored procedure as modular as possible, so that if someone decides to add or drop a column from the table sometime in the future, he will not get a "column count does not match" syntax error when running my procedure.