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?

possible duplicate of stackoverflow.com/questions/680801/… — Shakti Singh
– Shakti Singh, Commented Feb 24, 2011 at 16:19
That question didn't have any of the search terms I used so I didn't find it. Thanks for posting. — Ivar
– Ivar, Commented Feb 24, 2011 at 16:34

Avatar · Accepted Answer · 2022-05-30 09:04:02Z

65

Use CONCAT. Something like this:

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

Avatar

15.4k12 gold badges139 silver badges219 bronze badges

answered Feb 24, 2011 at 16:18

UltraInstinct

44.6k12 gold badges85 silver badges108 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1