Get mysql result of multiple rows in one with group_concat

Question

I have a table which has a column id and a column isadmin.

I want to execute this query, which works just fine:

SELECT id FROM mytable WHERE isadmin = TRUE;

But instead of getting multiple rows I would like to get one row in csv format. I found this link and created the following query, which does not work, I get a MySQL error:

SELECT GROUP_CONCAT(id SEPERATOR ',') FROM mytable WHERE isadmin = TRUE;

The error message is:

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SEPERATOR ', ') FROM mytable WHERE isadmin = TRUE' at line 1

If this is not enough information just tell me and I will provide them.

To a rough approximation, there is no problem in SQL for which GROUP_CONCAT need form any part of the answer - especially where application code, like PHP, is involved. — Strawberry, Jun 18 '16 at 22:16

score 2 · Accepted Answer · answered Jun 18 '16 at 20:23

2

The comma is the defaul separator so you don't need

 SELECT GROUP_CONCAT(id ) FROM mytable WHERE isadmin = TRUE;

anyway is separator and nt seperator

SELECT GROUP_CONCAT(id SEPARATOR ',') FROM mytable WHERE isadmin = TRUE;

answered Jun 18 '16 at 20:23

ScaisEdge

129,293
10
87
97

I read that about 50 times, still did not get it. This works well, thank you a lot :) – JRsz Jun 18 '16 at 20:26

Get mysql result of multiple rows in one with group_concat

1 Answers1