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?

Answer 1

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 ...

You can read about it here.