GROUP_CONCAT() with GROUP BY Expression Code:
mysql> CREATE TABLE members_details (MemberDetailId INTEGER PRIMARY KEY,MemberId INTEGER NOT NULL);
Query OK, 0 rows affected (0.03 sec)
mysql> INSERT INTO members_details VALUES (1,1),(2,1),(3,1),(4,2),(5,2),(6,2);
Query OK, 6 rows affected (0.00 sec)
Records: 6 Duplicates: 0 Warnings: 0
Code:
mysql> SELECT MemberId,CAST(GROUP_CONCAT(MemberDetailId)AS BINARY) AS MemberDetailId FROM members_details GROUP BY MemberId;
+----------+----------------+
| MemberId | MemberDetailId |
+----------+----------------+
| 1 | 1,2,3 |
| 2 | 4,5,6 |
+----------+----------------+
2 rows in set (0.00 sec)