select query in other way

[zohab]

hi all

 

i am using following query

 

"select * from tmp_table"

 

i have id,col1,col2,col3 columns in my table.

 

i want to select columns except id column.

 

i can do it by

 

"select col1,col2,col3 from tmp_table"

 

but i want to do it without selecting individual column.

 

something like

 

"select * from tmp_table where ---------"

 

any ideas?

 

 

[Cazrin]

It depends what you're wanting to select from the table.

 

If you're wanting to query a specific row, it's usually best to go by the row ID, so you'd want to keep that in your query.  Some more info on what you're wanting to actually query would be great

[fenway]

Why don't you want the ID back? Why does it matter?