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

Question

Hi all,

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

Answer 1

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

Answer 2

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