Hallo suppose you have a table with great number of columns (20 or 30), and you would like to specify every one but two or tree columns in a SELECT statement.
Is there a way to specify only those two or tree columns for omission (which would be the 'short' way to do the job) instead of specifying every column that needed (which would be the 'long' way to do the job). Example: The 'TName' table header: id | name | surname | dateOB | idSCHOOL | idCITY | idSTATE | sex | idParent1 | idParent2 | interests | weight | height | age | auditDate | idAudittor | .... You need every field except the 'dateOB' and 'idSCHOOL' Ordinary select wold be: SELECT id,name,surname,idCITY,idSTATE,sex,idParent1,idParent2,interests,weight,height,age,auditDate,idAudittor, .... FROM TName It is too long expression, is there a way to specify only 'dateOB' and 'idSCHOOL' - the two column that are unwanted in the result set - in order to make the SELECT shorter? The SELECT should return every column but the specified ones.