Mysql - How to update a column using another column's value plus some strings

Question

I have a table with the following column & value:

ColA = "8765" ColB = "2137"

I would like to update ColB in the same table to the following value:

ColC = "[8765][2137]"

How can I do it using phpmyadmin (meaning just sql syntax)?

user_255905 · Answer

UPDATE table SET ColC = CONCAT("[", ColA, "][", ColB, "]");

user_133802 · Answer

UPDATE
    myTable
SET
    ColC = CONCAT('[', ColA, '][', ColB, ']')
--WHERE...

user_2446600 · Answer

Use only this one! I've tested on the live server.

UPDATE table SET column_name = CONCAT( Column_A, ' ', Column_A );

In between single quotes will add a space. You can remove that if it is not required.