Try using select replace(replace(replace(json_arrayagg(fieldname), '"',''), '[', ''),']','') from table_name instead of using GROUP_CONCAT to overcome the limitation of GROUP_CONCAT in Mysql