[Resolved] Update w/ current value + string

[jacrewq]

Please help me to get the right syntax for UPDATE. I'm simply trying to add a string the the current value.

UPDATE table SET company = "CURRENT VALUE + SOME STRING" WHERE id = '25' LIMIT 1 ;

So how would I put "CURRENT VALUE + SOME STRING"?
If CURRENT VALUE is "Xyz" and STRING is " abc", i need the new value to be "Xyz abc".
Thanks!🙂

[eoghain]

Depends on what database you are using. This should work for MySQL:

UPDATE table
   SET company = CONCAT(company, "test")
 WHERE id = 25

[jacrewq]

thank you very much kind sir!