Mysql Json Development Tutorials, Guides & Insights

You can check if a specific key exists in a JSON document using the JSON_CONTAINS_PATH function.

SELECT name
FROM users
WHERE JSON_CONTAINS_PATH(preferences, 'one', '$.theme');

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: