0 votes
1 view
in SQL by (22.4k 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

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

1 Answer

0 votes
by (40.3k 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:

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

Related questions

0 votes
1 answer
0 votes
1 answer
0 votes
1 answer
Welcome to Intellipaat Community. Get your technical queries answered by top developers !


Categories

...