Select * Except .

Does this syntax work?

[ahmedtheking]

Is there some SQL syntax where by you can select all the fields apart from ones you specify?

[stajer]

SELECT * FROM table WHERE table_id NOT IN (comma separate list of table_id's)

[stajer]

Ah, unless you mean columns - you want to select all columns except these ones you enumerate. Then, no, there is no such syntax.

But, you could do several queries.

SELECT * FROM table WHERE table_ID = 0 will get you an empty query result set with just the column headers. Use your favorite programming language to to put the column headings into a list, strip out the column headings you don't want, then put that list into the select statement for the real query.

[ahmedtheking]

Hmmm lame. In the end I guess I've got to use PHP to separate the columns!