How to display all the column values in a single row separated by comma in MySQL?

Priyanka April 22, 2021 MySQL

Codeamend

We can get the column values in single row by , using GROUP_CONCAT() and CONCAT() methods. Check the below queries for reference.

Sample Code

select group_concat(concat('[',id,']')) AS ids  from table_name;

Total Views: 818

Posted in MySQL

Tagged Display all the column values in a single row, Display all the column values in a single row separated by comma in MySQL, Multiple row as comma separated single row, Mysql get values from all rows but in one record by comma separated