MySQL SELECT only 1 field with AS alias

advertisements

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?


No, it isn't. Suck it up and type them all out :)