Mysql Json Development Tutorials, Guides & Insights

• Aggregate values into a JSON array:

SELECT JSON_ARRAYAGG(name) AS user_names
FROM users;

Suppose you want to calculate the total quantity of products ordered by all customers. The quantity is stored within the JSON field order_details. You can extract this value and sum it across all rows using the following query:

SELECT SUM(CAST(JSON_UNQUOTE(JSON_EXTRACT(order_details, '$.quantity')) AS UNSIGNED)) AS total_quantity
FROM orders;