How to concat all values of single column in mysql

Question

I have column A in the Sample Table1. Column A has values as follows.

+----+
| A  |
+----+
| a1 |
| a2 |
| a3 |
| a4 |
| a5 |
+----+

I need a query that should give the following output. All the Values should be

"a1","a2","a3","a4","a5"

Is there a way?

Answer 1

You could use a combination of CONCAT and GROUP_CONCAT

Query

SELECT GROUP_CONCAT(CONCAT('"', A, '"')) AS `combined_A`
FROM `your_table_name`;

And if you want to remove the duplicates. Then use DISTINCT with GROUP_CONCAT.

Query

SELECT GROUP_CONCAT(DISTINCT CONCAT('"', `A`, '"')) AS `combined_A`
FROM `your_table_name`;

SQL Fiddle demo

Answer 2

Use GROUP_CONCAT() function to achive this.

SELECT GROUP_CONCAT(<Type your column name here> SEPARATOR ', ') FROM <Table Name>;

Query for your provided sample example :

SELECT GROUP_CONCAT(A SEPARATOR ', ')  FROM Table1;