Select multiple columns with single alias

Question

What's the alternate to

select table_name.* as colAlias from table_name

I assume this used to work pre 5.5 MySQL.

Answer 1

SELECT CONCAT(col1,', ',col2,', ',col3) AS cols
    FROM table_name ORDER BY cols;

or also

SELECT CONCAT(col1,' ',col2,' ',col3) AS cols
    FROM table_name ORDER BY cols;