Use: SELECT t.*, x.combinedsolutions FROM TICKETS t LEFT JOIN (SELECT s.ticket_id, GROUP_CONCAT(s.soution) AS combinedsolutions FROM SOLUTIONS s GROUP BY s.ticket_id) x ON x.ticket_id = t.ticket_id Alternate: SELECT t.*, (SELECT GROUP_CONCAT(s.soution) FROM SOLUTIONS s WHERE s.ticket_id = t.ticket_id) AS combinedsolutions FROM TICKETS t
Looks as though GROUP_CONCAT expects that value to be a string. I just ran into the same problem. Solved it by converting the int column to a string like so: SELECT rec_id,GROUP_CONCAT(CONVERT(user_id, CHAR(8))) FROM t1 GROUP BY rec_id Figured I’d share in case you were still having an issue with this.
You need to use the DISTINCT option: GROUP_CONCAT(DISTINCT animal)
SELECT a.nid, GROUP_CONCAT(b.name ORDER BY b.id) DepartmentName FROM Notes a INNER JOIN Positions b ON FIND_IN_SET(b.id, a.forDepts) > 0 GROUP BY a.nid SQLFiddle Demo
With the newer versions of MySQL, you can use JSON_OBJECT function to achieve the desired result, like so: GROUP_CONCAT( JSON_OBJECT( ‘name’, name, ‘phone’, phone ) ) AS list To get the SQL response ready to be parsed as an array: CONCAT( ‘[‘, GROUP_CONCAT( JSON_OBJECT( ‘name’, name, ‘phone’, phone ) ), ‘]’ ) AS list This … Read more
select id, group_concat(`Name` separator ‘,’) as `ColumnName` from ( select id, concat(`Name`, ‘:’, group_concat(`Value` separator ‘,’)) as `Name` from mytbl group by id, `Name` ) tbl group by id; You can see it implemented here : Sql Fiddle Demo. Exactly what you need. Update Splitting in two steps. First we get a table having all … Read more
Looks like you’re missing the SEPARATOR keyword in the GROUP_CONCAT function. GROUP_CONCAT(artists.artistname SEPARATOR ‘—-‘) The way you’ve written it, you’re concatenating artists.artistname with the ‘—-‘ string using the default comma separator.
Sure, see http://dev.mysql.com/doc/refman/…tions.html#function_group-concat: SELECT student_name, GROUP_CONCAT(DISTINCT test_score ORDER BY test_score DESC SEPARATOR ‘ ‘) FROM student GROUP BY student_name;
You can use ORDER BY inside the GROUP_CONCAT function in this way: SELECT li.client_id, group_concat(li.percentage ORDER BY li.views ASC) AS views, group_concat(li.percentage ORDER BY li.percentage ASC) FROM li GROUP BY client_id
GROUP_CONCAT has DISTINCT attribute: SELECT GROUP_CONCAT(DISTINCT categories ORDER BY categories ASC SEPARATOR ‘ ‘) FROM table