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

Select0r · Accepted Answer · 2010-02-09 08:56:05Z

88

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

answered Feb 9, 2010 at 8:56

Select0r

12.7k11 gold badges51 silver badges70 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

David Hedlund · Accepted Answer · 2010-02-09 08:55:45Z

15

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

answered Feb 9, 2010 at 8:55

David Hedlund

130k33 gold badges205 silver badges223 bronze badges

mohammed wazeem · Accepted Answer · 2020-04-19 14:54:19Z

2

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.

mohammed wazeem

1,3501 gold badge11 silver badges26 bronze badges

answered Apr 19, 2020 at 11:02

user2446600

333 bronze badges