set prefix (e.g. tablename) on result-fields

[dan dan]

hi out there,

[don´t know, if it´s a kind of newbie-question, so sorry when it´s off-topic]

when e.g. doing

SELECT * FROM tableA;

is it possible to place an option, that all fields in the result set contain a prefix - for example the table-name ("tableA")?

tableA_field1 tableA_field2
--------------------------
foo bar
foo2 bar2
-------------
2 rows in set


i would do anything for such an option :-))

bye

yours dan