How can I append a string to an existing field in MySQL?

Question

I want to update the code on all my records to what they currently are plus _standard any ideas?

So for example, if the codes are apple_1 and apple_2 I need them to be apple_1_standard and apple_2_standard

Before:

id   code

------------

1    apple_1 

1    apple_2

Psuedo Query:

update categories set code = code + "_standard" where id = 1;

Expected result:

id   code

----------------------

1    apple_1_standard 

1    apple_2_standard

Answer 1

You must use the CONCAT() function in MySQL for string concatenation like this:

UPDATE categories SET code = CONCAT(code, '_standard') WHERE id = 1;

For more information, refer to this docs:

https://dev.mysql.com/doc/refman/8.0/en/string-functions.html#function_concat