Mysql - How to update a column using another column's value plus some strings
UPDATE table SET ColC = CONCAT("[", ColA, "][", ColB, "]");
UPDATE
myTable
SET
ColC = CONCAT('[', ColA, '][', ColB, ']')
--WHERE...
UPDATE table SET ColC = CONCAT("[", ColA, "][", ColB, "]");
UPDATE
myTable
SET
ColC = CONCAT('[', ColA, '][', ColB, ']')
--WHERE...