How to use GROUP_CONCAT with different SEPARATOR in MySQL?

1.	How to use GROUP_CONCAT with different SEPARATOR in MySQL?
Answer» SELECT ID, GROUP_CONCAT(DEPARTMENT SEPARATOR ' ') AS department FROM EMPLOYEE GROUP by id;

Discussion