zohab Posted January 7, 2008 Share Posted January 7, 2008 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? Quote Link to comment https://forums.phpfreaks.com/topic/84848-select-query-in-other-way/ Share on other sites More sharing options...
Cazrin Posted January 7, 2008 Share Posted January 7, 2008 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 Quote Link to comment https://forums.phpfreaks.com/topic/84848-select-query-in-other-way/#findComment-432555 Share on other sites More sharing options...
fenway Posted January 7, 2008 Share Posted January 7, 2008 Why don't you want the ID back? Why does it matter? Quote Link to comment https://forums.phpfreaks.com/topic/84848-select-query-in-other-way/#findComment-432703 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.