comma separated string of selected values in mysql

Question

I want to convert selected values into a comma separated string in MySQL  My initial code is as follows   SELECT id FROM table level where parent id 4    Which produced    5   6   9   10   12   14   15   17   18   779    My desired output would look like this    5 6 9 10 12 14 15 17 18 779

User · Answer

Use group concat   function of mysql   SELECT GROUP CONCAT id  FROM table level where parent id 4 GROUP BY parent id    It ll give you concatenated string like     5 6 9 10 12 14 15 17 18 779

User · Answer

Just so for people doing it in SQL server  use STRING AGG to get similar results

User · Answer

If you have multiple rows for parent id   SELECT GROUP CONCAT id  FROM table level where parent id 4 GROUP BY parent id    If you want to replace space with comma   SELECT REPLACE id          FROM table level where parent id 4

User · Answer

First to set group concat max len  otherwise it will not give you all the result   SET GLOBAL  group concat max len   999999  SELECT GROUP CONCAT id   FROM table level where parent id 4 group by parent id

User · Answer

Try this  SELECT CONCAT     GROUP CONCAT id       FROM table level  where parent id 4 group by parent id    Result will be    5 6 9 10 12 14 15 17 18 779

User · Answer

The default separator between values in a group is comma     To specify any other separator  use SEPARATOR as shown below   SELECT GROUP CONCAT id SEPARATOR      FROM  table level  WHERE  parent id  4 GROUP BY  parent id        5 6 9 10 12 14 15 17 18 779   To eliminate the separator  then use SEPARATOR     SELECT GROUP CONCAT id SEPARATOR     FROM  table level  WHERE  parent id  4 GROUP BY  parent id     Refer for more info GROUP CONCAT

User · Answer

Use group concat method in mysql

User · Answer

Check this  SELECT GROUP CONCAT id   FROM table level where parent id 4 group by parent id

[mysql] comma separated string of selected values in mysql

Examples related to mysql

Examples related to select

Examples related to comma