CODEWITHSUNDEEP
mysqlconcatenation
Ivar
Ivar

Reputation: 796

Add text to a field with sql query

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?

Upvotes: 27

Views: 52852

Answers (1)

UltraInstinct
UltraInstinct

Reputation: 44434

Use CONCAT. Something like this:

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

Upvotes: 64

Related Questions