Add text to a field with sql query

I have a开发者_JS百科 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?

Use CONCAT. Something like this:

UPDATE mytable SET myfield = CONCAT('f21 -', myfield)