Append variable to column name during select statement

[eluser]mvdg27[/eluser]
Hi guys,

I'm wondering if there is an easier way to achieve a MySQL select statement where a specific variable name is appended to the column names. Right now I add the variable name explicitly to each column, but perhaps this can be done more easy?

Code:

$var = 'my_var';
$this->db->select('id AS id_'.$var.', foo AS foo_'.$var .... etc. ect.);

Also, this would be useful for when I want to do a select all ('*'), statement .. does anyone know of how this is done?

Thanks, in advance!

-Michiel