How to add a value before the current one?

Question

MySQL

There are lines with values:
1
2
3
4
What query should be executed to get the values
​​dd/1
dd/2
dd/3
dd/4 as output?
That is, add before the current value "dd/"

Answer 1

select concat('dd/', fieldname) ...