wildcard column aliasing after a join

[breyguhn]

I'm joining several tables together, each with a good number of
columns. These columns are often named the same thing in different
tables (eg 'uid' for the primary key). I can obviously alias each
column separately:

select users.uid as userid, profiles.uid as profileid, ...

This quickly gets tedious and strikes me as a little kludgy when used
across dozens of columns.

Is there any way to, say, prefix each table's columns with that table
name so they can be easily distinguished?

Ideally there'd be something along the lines of:

select users.* as 'users_'.*, profiles.* as 'profiles_'.*, ...

which would then return

+-----------+-------------------+-----+-------------+-
| users_uid | users_othercolumn | ... | profiles_uid| ...
+-----------+-------------+-----+-----+-------------+-

Is there anything that would give a similar effect? I can't see
anything obvious in the docs...

many thanks
Simon Rodgers
Cambridge, UK