Add text to a field with sql query

Question

I have a field in the mysql database and I would like to insert text in front of all the values in that field.

I would like to add "F21 - " So the field would be "F21 - product name" instead of "product name"

I need a simple sql query

any ideas?

Answer 1

Use concat. Something like this:

update mytable set myfield = concat('f21 -',myfield)