Sum Json Values Development Tutorials, Guides & Insights
Unlock 1+ expert-curated sum json values tutorials, real-world code snippets, and modern dev strategies. From fundamentals to advanced topics, boost your sum json values skills on DeveloperBreeze.
Adblocker Detected
It looks like you're using an adblocker. Our website relies on ads to keep running. Please consider disabling your adblocker to support us and access the content.
Selecting the Sum of a JSON Property in MySQL
Tutorial August 17, 2024
json mysql
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;