MySQL: Selecting all columns in a table plus one column from the same table

Question

I have a table with many columns let say column1,....,column20. I don't want to scroll everytime to the end of the result table to see the value of column20. In mssql I usually do SELECT column20, * FROM TABLE but apparently this is not valid in MySQL. Any hints? (I also don't want to select all columns explicitly in the select statement)

Answer 1

You have to give the table name in your query, otherwise mysql complains :

SELECT column20, mytable.* FROM mytable

PS: I have absolutely no idea as to why, because SELECT *, column20 FROM mytable works just fine... Strange things happens sometimes ^^