mysql> CREATE TABLE members (ID INTEGER PRIMARY KEY,names VARCHAR(100));
Query OK, 0 rows affected (0.04 sec)

mysql> INSERT INTO members VALUES (1,'Ragavan');
Query OK, 1 row affected (0.00 sec)

mysql> INSERT INTO members VALUES (2,'Ragavan~');
Query OK, 1 row affected (0.00 sec)

mysql> INSERT INTO members VALUES (3,'Ragavan');
Query OK, 1 row affected (0.00 sec)

mysql> INSERT INTO members VALUES (4,'Rajesh');
Query OK, 1 row affected (0.00 sec)

mysql> INSERT INTO members VALUES (5,'Rahul');
Query OK, 1 row affected (0.00 sec)

mysql> SELECT GROUP_CONCAT(names)FROM members;
+---------------------------------------+
| GROUP_CONCAT(names)                   |
+---------------------------------------+
| Ragavan,Ragavan~,Ragavan,Rajesh,Rahul |
+---------------------------------------+
1 row in set (0.00 sec)

-- Now getting the Distinct Names using GROUP_CONCAT()

mysql> SELECT GROUP_CONCAT(DISTINCT names)FROM members;
+-------------------------------+
| GROUP_CONCAT(DISTINCT names)  |
+-------------------------------+
| Ragavan,Ragavan~,Rajesh,Rahul |
+-------------------------------+
1 row in set (0.00 sec)