How to select multiple columns from a table excluding some columns?

Question

I tried:

SELECT *!=[column name i want to exclude] from tablename;

it didn't work.

Possible duplicate of [Select all columns except one in MySQL?](http://stackoverflow.com/questions/9122/select-all-columns-except-one-in-mysql) — Dasrath, Dec 02 '15 at 10:21

score 7 · Answer 1 · answered Dec 02 '15 at 10:18

7

select column1, column2, column4, column7
from tablename;

should be the way to go.

answered Dec 02 '15 at 10:18

Non Plus Ultra

what if I have to select from a table of say 50 columns and exclude only 5 columns? thank you very much. your help is appreciated. – sriram unnam Dec 02 '15 at 10:20
1

there is a solution with metadata. It that is acceptable for you :) https://stackoverflow.com/questions/9122/select-all-columns-except-one-in-mysql – Non Plus Ultra Dec 02 '15 at 10:34
SELECT *, NULL AS salary FROM users; this is the solution which came close to my query, in the link you have provided. Thanks. – sriram unnam Dec 02 '15 at 10:47
is there a way to exclude the column itself – sriram unnam Dec 02 '15 at 10:50

1 Answers1