Concatenation of fields in different rows in mysql

Question

I have a query in mysql that it's result is as below:

val1_col1A  val1_col2A  val1_col1B val1_col2B
val1_col1A  val1_col2A  val2_col1B val2_col2B
val1_col1A  val1_col2A  val3_col1B val3_col2B

like this :

1 reza math 20
1 reza c++  19
1 reza C#   17

my query is :

SELECT col1A,col2A,col1B,col2B
FROM  A join B
ON col3A=col3B

I want to have a query that it result be as below :

val1_col1A  val1_col2A  val1_col1B,val2_col1B,val3_col1B val1_col2B,val2_col2B,val3_col2B

Like this :

1 reza math,c++,c# 20,19,17

Omesh · Accepted Answer · 2012-08-10 11:52:53Z

1

I think this is what you are looking for:

SELECT CONCAT(GROUP_CONCAT(DISTINCT val1_col1A), 
              GROUP_CONCAT(DISTINCT val1_col2A), 
              GROUP_CONCAT(DISTINCT val1_col1B),
              GROUP_CONCAT(DISTINCT val1_col2B)) AS value
FROM table_name;

answered Aug 10, 2012 at 11:52

Omesh

29.4k6 gold badges44 silver badges51 bronze badges

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

Collectives™ on Stack Overflow

Concatenation of fields in different rows in mysql

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