How to concatenate multiple rows into a single text string without using loop?

Question

Suppose i have a table with the following data:

ClientID    ClientName
3           saurabh Malhotra
4           patel Mon
6           Sajith raju
7           Vipin parmar
8           Monoj trivedi

We need to concatenate the ClientName column like the following:

saurabh Malhotra, patelMon, Sajith raju, Vipin parmar, Monoj trivedi

possible duplicate of How to use GROUP BY to concatenate strings in MySQL? — mjsqu
– mjsqu, Commented Jul 23, 2015 at 5:26
you are getting completely wrong..please read question again and then compare.. — Himanshu Upadhyay
– Himanshu Upadhyay, Commented Jul 23, 2015 at 5:28

Mukesh Kalgude · Accepted Answer · 2015-07-23 05:30:18Z

1

Try this query

select 
     group_concat(ClientName  separator ',') as ClientName 
from (select 1 as tempcol,
           ClientName 
     from tablename)tbl
group by tempcol

answered Jul 23, 2015 at 5:30

Mukesh Kalgude

4,8542 gold badges20 silver badges32 bronze badges

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

Comments

Community · Accepted Answer · 2017-05-23 12:24:09Z

1

Try This :)

SELECT GROUP_CONCAT(ClientName) FROM Your_table_name

MySQL : Multiple row as comma separated single row

edited May 23, 2017 at 12:24

CommunityBot

11 silver badge

answered Jul 23, 2015 at 5:30

Vishnu

3754 silver badges16 bronze badges

Collectives™ on Stack Overflow

How to concatenate multiple rows into a single text string without using loop?

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related