Alextrapixel/mysql_show_as_array.md

Created September 12, 2025 13:27

Star (0) You must be signed in to star a gist
Fork (0) You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/Alextrapixel/a176814c57de0ee05857777711efe551.js"></script>
Save Alextrapixel/a176814c57de0ee05857777711efe551 to your computer and use it in GitHub Desktop.

Download ZIP

Show column as array in mysql

Raw

mysql_show_as_array.md

If your table has:

name	small	big
apple	10	20
banana	5	15

We can make this query:

SELECT 
    name,
    JSON_ARRAY(
        JSON_OBJECT('size', 'small', 'quantity', small),
        JSON_OBJECT('size', 'big', 'quantity', big)
    ) AS detail
FROM your_table;

And the query will return:

name	detail
apple	`[{"size": "small", "quantity": 10}, {"size": "big", "quantity": 20}]`
banana	`[{"size": "small", "quantity": 5}, {"size": "big", "quantity": 15}]`