Is there a MySQL equivalent to PostgreSQL array_to_string

Question

I'm trying to find the MySQL equivalent of the PostgreSQL functions array and array_to_string and came across this post but asking for oracle9i which doesn't help me. I need to achieve this with MySQL but even Google can't seem to find any suitable answers.

So you don't have to read two posts, here is a repeat of the question:

In PostgreSQL, using the array and array_to_string functions can do the following:

Given the table "people":
id | name
---------
1  | bob
2  | alice
3  | jon
The SQL:
SELECT array_to_string(array(SELECT name FROM people), ',') AS names;
Will return:
names
-------------
bob,alice,jon

Anyone have any ideas how to achieve this in MySQL?

Chandu · Accepted Answer · 2011-05-28 14:55:31Z

8

Try GROUP_CONCAT . e.g:

SELECT GROUP_CONCAT(name) AS names FROM people GROUP BY id;

answered May 28, 2011 at 14:55

Chandu

83.2k19 gold badges137 silver badges136 bronze badges

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

4 Comments

Johan Over a year ago

@DangerPaws, See: dev.mysql.com/doc/refman/5.5/en/… for more details.

GoneAway Over a year ago

Excellent! Thanks for that! Exactly what I needed :) @Johan Thanks for the link

GoneAway Over a year ago

I take it from the documentation that I can't put a SELECT statement inside the GROUP_CONCAT function?

GoneAway Over a year ago

@myself, correction you can put a SELECT statement inside the GROUP_CONCAT but need to wrap the SELECT statement in an extra pair of brackets like this: GROUP_CONCAT((SELECT...))

Collectives™ on Stack Overflow

Is there a MySQL equivalent to PostgreSQL array_to_string

1 Answer 1

4 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related