concat sql rows

Question

Suppose I have this rows in a table

hello
guys
how
are
you?

My expected result is a single row like this one:

hello, guys, how, are, you?

What can I do?

artemis · Accepted Answer · 2019-09-24 17:30:08Z

4

As GordonLinoff mentioned in the comment, GROUP_CONCAT works.

I don't know your table names or table structures, but you can do something like:

SELECT GROUP_CONCAT(col_name) FROM table WHERE ...

answered Sep 24, 2019 at 17:30

artemis

7,36114 gold badges65 silver badges119 bronze badges

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

1 Comment

I just saw @GordonLinoff posted the same thing I did.