JSON Object Functions
JSON_OBJECT() builds a JSON object from key-value pairs. JSON_KEYS() returns the top-level keys. JSON_MERGE_PATCH() merges objects.
MySQL
Intermediate
4 min read
JSON Object Functions
Example
-- Build JSON object dynamically
SELECT JSON_OBJECT('name', name, 'price', price)
FROM products;
-- Get top-level keys
SELECT JSON_KEYS(attributes) FROM products WHERE id = 1;
-- ["color", "ram", "gpu"]
-- Merge two JSON objects
SELECT JSON_MERGE_PATCH('{"a":1}', '{"b":2}');
-- {"a": 1, "b": 2} Pro Tip
JSON_MERGE_PATCH overwrites conflicting keys; JSON_MERGE_PRESERVE keeps both as arrays.