How to insert characters into a varchar field in MySQL?
For example, in the update with trim vc you can remove certain characters from a field varchar ... but add?
Example: update tabela set campo = TRIM(leading '11' from campo);
MySQL has the function concat() to concatenate strings as it can receive N arguments you can put anything at the beginning and at the end.
update tabela set campo = concat('inicio ', campo, ' fim') where id = ?
You can use the || (string concatenation):
select 'Hello' || ' ' || 'World'; returns Hello World .