I'd like to select all columns in a table, but give only one of them an alias.
I have this table:
id
base
window
thickness
shading
shape
... and many more columns
Now, I want to select the base with an alias, like so: SELECT base AS structure.
But I want to select all the other fields as well, without having to type them all out.
I tried SELECT *, base AS structure, but it gives me an error.
In truth, that's not even really what I want, because I don't want base to show up at all.
Is this at all possible?
