steelerman99 Posted February 9, 2008 Share Posted February 9, 2008 Hello, I was wondering if you can modify a SELECT query to return all columns but just one or two. We know that doing " Select * " will display all columns of the table. What if we have say 50 columns, but we only want to exclude one or two columns? Would we have to type " SELECT col1, col2, col3, .......... , col 49, col50 FROM...." or is there an easier way to do this? Thanks!! Link to comment https://forums.phpfreaks.com/topic/90254-display-all-columns-but-one/ Share on other sites More sharing options...
toplay Posted February 9, 2008 Share Posted February 9, 2008 Would we have to type " SELECT col1, col2, col3, .......... , col 49, col50 FROM...." ? Yes. Specify just the columns you want (data returned). http://dev.mysql.com/doc/refman/5.0/en/select.html Link to comment https://forums.phpfreaks.com/topic/90254-display-all-columns-but-one/#findComment-462718 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.