concatenate strings of rows according to column

Question

I hava table

MsgID    Msg              value
ms001    I am here.       ----
ms001    Wher are you     dsdad
ms002    who r u          gfsdfdf
ms002    where is this    dadad
ms002    I am goin        adadad

Is this possible to get result like this by MySQL query

ms001    I am here. Wher are you
ms002    who r u wher is this I am goin

You will need to read through Group_concat

Akhil
– Akhil

2013-08-01 04:40:30 +00:00
Commented Aug 1, 2013 at 4:40 — Akhil
– Akhil, Commented Aug 1, 2013 at 4:40

Prahalad Gaggar · Accepted Answer · 2013-08-01 04:41:19Z

6

Read about group_concat

SELECT MsgID , GROUP_CONCAT(Msg SEPARATOR ' ') AS Msg
FROM table1
GROUP BY MsgID;

SQL Fiddle

answered Aug 1, 2013 at 4:41

Prahalad Gaggar

11.6k17 gold badges58 silver badges73 bronze badges

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

Collectives™ on Stack Overflow

concatenate strings of rows according to column

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related