Mysql – How to update a column using another column’s value plus some strings May 2, 2023 by Tarik UPDATE table SET ColC = CONCAT("[", ColA, "][", ColB, "]");