MySQL concat multiple row under one ID

Question

I have a MySQL table called mst_order_details and it has column (order no) and it can be same order no it more time.

Each order number have related technique column I want to concat technique column according to order no

mst_order_details table :

order no   Technique
-------------------------
1           heat_seal
1           laser_cut
1           oil_filter
2           diamond cut
2           diamond cut

Output should be like this :

order no    Technique
---------------------------------------------
 1          heat_seal/laser_cut/ oil_filter
 2          diamond cut

Please read [How do I ask a good question?](https://stackoverflow.com/help/how-to-ask) and [What topics can I ask about here?](https://stackoverflow.com/help/on-topic). Research, try something, add your code & point your problem. Pay attention to formatting question — pirho, Dec 05 '17 at 09:19

Andrey Yerokhin · Accepted Answer · 2017-12-05T09:29:32.387

3

You can use GROUP_CONCAT:

SELECT `order no`, GROUP_CONCAT(DISTINCT `Technique` SEPARATOR '/') FROM mst_order_details GROUP BY `order no`;

edited Dec 05 '17 at 09:29

answered Dec 05 '17 at 09:20

Andrey Yerokhin

273
1
7

1

you should add DISTINCT to technique, no? – backbone Dec 05 '17 at 09:24
@backbone it depends on requirements – Andrey Yerokhin Dec 05 '17 at 09:27
he wanted the row 2 | diamond_cut to show up only one time in the answer. – backbone Dec 05 '17 at 09:28
Yes, you are right. I missed it. – Andrey Yerokhin Dec 05 '17 at 09:29
thank you very much for the quick response and support ...it worked . – Hasitha Dec 05 '17 at 09:37

MySQL concat multiple row under one ID

1 Answers1