MYSQL Table with 2 columns.Col1 Duplicate ,Col2 unique values

Question

I am using mysql , Table with 2 Columns

Col1  |  Col1 
------+-------+
a@a   |   ab  |
a@a   |   cd  |
b@b   |   ab  |
b@b   |   cd  |

I want result like this

Col1  |  Col1 
------+--------+
a@a   |   abcd |
b@b   |   abcd |

How can i achieve this using SQL please help me. Thanks.

Mahmoud Gamal · Accepted Answer · 2013-07-04 12:59:00Z

2

Use GROUP_CONCAT with no SEPARATOR like so:

SELECT col1, GROUP_CONCAT(col2 SEPARATOR '') AS col2
FROM tablename
GROUP BY col1;

See it in action here:

This will give you:

| COL1 | COL2 |
---------------
|  a@a | abcd |
|  b@b | abcd |

answered Jul 4, 2013 at 12:59

Mahmoud Gamal

80.3k18 gold badges143 silver badges168 bronze badges

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

1 Answer 1