I have a column of data, e.g. as follows:

select league_id from leagues

This gives me a single column (league_id) and 100 rows for that column.

I want to convert it into a single cell (1 row, 1 column) with the following structure:

[1001, 1002, 42022, 203412,  24252, etc..]

Essentially converting the rows into one big array.

There must be a way of doing it but can't see how.

I'm using MariaDB 10.2.

CodePudding user response：

You can use the GROUP_CONCAT() function for that.

Usage is straightforward:

SELECT group_concat(val) 
  FROM tab

gives you

See db<>fiddle.

(Note: Before MariaDB 10.3.3 you cannot use the LIMIT clause with GROUP_CONCAT, in case you should need that).