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)?

Answer 1

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

Answer 2

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