Back

Explore Courses Blog Tutorials Interview Questions
0 votes
2 views
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

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.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:

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

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 Dec 26, 2020 in SQL by Appu (6.1k points)

Browse Categories

...