#group-concat

Fixed Can I concatenate multiple MySQL rows into one field? #dev #it #asnwer

Can I concatenate multiple MySQL rows into one field?

Using MySQL, I can do something like:

SELECT hobbies FROM peoples_hobbies WHERE person_id = 5;

and get:

shopping fishing coding

but instead I just want 1 row, 1 col:

shopping, fishing, coding

The reason is that I’m selecting multiple values from multiple tables, and after all the joins I’ve got a lot more rows than I’d like.

I’ve looked…

Fixed Concatenate many rows into a single text string? #dev #it #asnwer

Concatenate many rows into a single text string?

Consider a database table holding names, with three rows:

Peter Paul Mary

Is there an easy way to turn this into a single string of Peter, Paul, Mary?

Answer: Concatenate many rows into a single text string?

Depends on your database vendor. MySQL has concat_ws. MS SQL Server expects you to do it in your client application.

Update: you could also…

How to: Can I concatenate multiple MySQL rows into one field?

Can I concatenate multiple MySQL rows into one field?

Using MySQL, I can do something like:

SELECT hobbies FROM peoples_hobbies WHERE person_id = 5;

and get:

shopping fishing coding

but instead I just want 1 row, 1 col:

shopping, fishing, coding

The reason is that I’m selecting multiple values from multiple tables, and after all the joins I’ve got a lot more rows than I’d like.

I’ve looked…

How to: Concatenate many rows into a single text string?

Concatenate many rows into a single text string?

Consider a database table holding names, with three rows:

Peter Paul Mary

Is there an easy way to turn this into a single string of Peter, Paul, Mary?

Answer: Concatenate many rows into a single text string?

This can be useful too

create table #test (id int,name varchar(10)) use separate inserts on older versions of SQL Server insert into #test…