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;

My Output:


but instead I just want 1 row, 1 col:

Expected Output:

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 for a function on MySQL Doc and it doesn’t look like the CONCAT or CONCAT_WS functions accept result sets, so does anyone here know how to do this?