David Carrdcblogdev.hashnode.devยทMar 25, 2014Retain rows when using a GROUP BY with GROUP_CONCATKeep rows that would normally be lost when selecting rows using a COUNT and GROUP By. To keep say another column and merge them into a column comma separated by using a GROUP_CONCAT function. Take this example. SELECT COUNT(tickets.memberID) ...Add a thoughtful commentNo comments yetBe the first to start the conversation.