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?](http://stackoverflow.com/questions/149772/how-to-use-group-by-to-concatenate-strings-in-mysql) — mjsqu, Jul 23 '15 at 05:26
you are getting completely wrong..please read question again and then compare.. — Himanshu Upadhyay, Jul 23 '15 at 05:28

score 1 · Accepted Answer · answered Jul 23 '15 at 05:30

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 '15 at 05:30

Mukesh Kalgude

4,814
2
17
32

score 1 · Answer 2 · edited May 23 '17 at 12:24

1

Try This :)

SELECT GROUP_CONCAT(ClientName) FROM Your_table_name

MySQL : Multiple row as comma separated single row

edited May 23 '17 at 12:24

Community

1
1

answered Jul 23 '15 at 05:30

Vishnu

375
4
16

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

2 Answers2