Explore Courses Blog Tutorials Interview Questions
0 votes
in SQL by (20.3k 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 (40.7k 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:

Related questions

0 votes
1 answer
0 votes
1 answer
asked Jul 22, 2019 in SQL by Tech4ever (20.3k points)
0 votes
1 answer
asked Jul 29, 2019 in SQL by Tech4ever (20.3k points)
Welcome to Intellipaat Community. Get your technical queries answered by top developers!

30.5k questions

32.5k answers


108k users

Browse Categories