0 votes
1 view
in SQL by (15.8k points)

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


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

1 Answer

0 votes
by (32.2k points)

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: