PHP MYSQL COMBINE STRING

Question

Table `names`
ID | name 
---------
1  | Alex
2  | John
3  | Alex
4  | Alex
5  | Alice
6  | Monica

SELECT `name` FROM `names` GROUP BY `name`
Alex
John
Alice
MOnica

so, I need to make like this

SELECT `name`, COMBINE_STRING(`ID`, SEPARATOR `,`) AS `IDS` FROM `names` GROUP BY `name`

and the result should be like this :

and the result will be like this :

NAME | IDS
------------
Alex   1,3,4
John   2
Alice  5
MOnica 6

but as you see that mysql function COMBINE_STRING doesn't exist, so any ideas how to do this?

score 1 · Answer 1 · answered Jun 09 '15 at 07:28

1

Change COMBINE_STRING to group_concat so it becomes

SELECT `name`, group_concat(`ID`) AS `IDS` FROM `names` GROUP BY `name`

, is default separator for the group_concat when explicitly not provided.

answered Jun 09 '15 at 07:28

Abhik Chakraborty

44,654
6
52
63

score 0 · Accepted Answer · answered Jun 09 '15 at 07:28

0

Simply you can use GROUP_CONCAT function of MySql which'll work for you as like of your COMBINE_STRING

SELECT `name`, GROUP_CONCAT(`ID`) AS `IDS` FROM `names` GROUP BY `name`

answered Jun 09 '15 at 07:28

Narendrasingh Sisodia

21,247
6
47
54

Thanks, but actually I already figured it out by my self, but anyway ur example is that what I need, thx a lot! – Aleksandr Sasha Jun 09 '15 at 07:33
@AleksandrSasha You're welcome. Glad to help. (_FYI: You can accept or upvote an answer which really helps you_) – Narendrasingh Sisodia Jun 09 '15 at 07:35

PHP MYSQL COMBINE STRING

2 Answers2