May 24, 2012

Comment: GROUP_CONCAT useful GROUP BY extension

A litte problem I had with the group_concat function was when selecting integers only I was getting a blob instead of a string to solve this I used a cast: SELECT GROUP_CONCAT(CAST(myInt as CHAR)) myInts FROM aTable;