DeveloperBreeze

Mysql Json Tutorial Development Tutorials, Guides & Insights

Unlock 1+ expert-curated mysql json tutorial tutorials, real-world code snippets, and modern dev strategies. From fundamentals to advanced topics, boost your mysql json tutorial skills on DeveloperBreeze.

Selecting the Sum of a JSON Property in MySQL

Tutorial August 17, 2024
json mysql 

INSERT INTO orders (customer_name, order_details) VALUES
('Alice', '{"quantity": 3, "price": 19.99, "product": "T-shirt"}'),
('Bob', '{"quantity": 1, "price": 9.99, "product": "Cap"}'),
('Charlie', '{"quantity": 2, "price": 15.49, "product": "Mug"}');

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:

Read More