Campo testuale in select MySQL

[piero.mac]

select concat('miotesto', campo) AS Campo_T from ...