How to add a row to an existing field in MySQL?

Question

I want to update the code in my entire post to the point that they are currently 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 Request:

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

Expected Result:

 id code ---------------------- 1 apple_1_standard 1 apple_2_standard 

Answer 1

You need to use the CONCAT() function in MySQL to concatenate strings:

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