Answers for "use concat in group_concat"

use concat in group_concat

SELECT GROUP_CONCAT(
	CONCAT(
		'{ID:',	ID,
        ',ParentID:', ParentID,
        '}'          
	) SEPARATOR ","
) FROM table

Posted by: Guest on February-15-2022

use group_concat in concat

SELECT
    CONCAT(`Name`, ':', GROUP_CONCAT(`Value` SEPARATOR ',')) AS `Name`
FROM table
GROUP BY `Name`

Posted by: Guest on February-15-2022

Code answers related to "use concat in group_concat"