mariadb remove prop JSON
+----+--------+-------+-------+---------------------------------+ | id | name | price | stock | attr | +----+--------+-------+-------+---------------------------------+ | 2 | Shirt | 10.50 | 78 | {"size": 42, "colour": "white"} | | 3 | Blouse | 17.00 | 15 | {"colour": "white"} | +----+--------+-------+-------+---------------------------------+ UPDATE Clothes SET attr = JSON_REMOVE(attr, '$.size'); WHERE id = 2; +----+--------+-------+-------+---------------------------------+ | id | name | price | stock | attr | +----+--------+-------+-------+---------------------------------+ | 2 | Shirt | 10.50 | 78 | {"colour": "white"} | | 3 | Blouse | 17.00 | 15 | {"colour": "white"} | +----+--------+-------+-------+---------------------------------+
