Top "Group-concat" questions

sqlite3 JOIN, GROUP_CONCAT using distinct with custom separator

Given a table of "events" where each event may be associated with zero or more "speakers" and zero or more "…

sql sqlite group-concat

How to prevent GROUP_CONCAT from creating a result when no input data is present?

Given the following MySQL query: SELECT `show`.`id` , GROUP_CONCAT( `showClips`.`clipId` ORDER BY `position` ASC ) AS 'playlist' FROM `show` …

mysql group-concat

MySQL: combining multiple values after a join into one result column

I have a database with a table for publications, each of which can have multiple authors that are stored in …

mysql sql left-join group-concat

Select first and last row from group_concat when grouping sortable days

Referring to my previous questions about the group concat Mysql again, group by and display rest of rows i need …

mysql group-concat

GROUP CONCAT not working for some reason

I'm forming a select statement and am getting this error. FUNCTION GROUP_CONCAT does not exist. Check the 'Function Name …

mysql sql select group-concat