By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE cart (
quote_id INT,
items JSON
);
INSERT INTO cart VALUES
(0, '[{"a":42,"b":"test4"},{"a":32,"b":"test3"}]');
SELECT JSON_REMOVE(items,
IFNULL(SUBSTR(JSON_UNQUOTE(JSON_SEARCH(items, 'one', 'test3')), 1, LOCATE('.', JSON_UNQUOTE(JSON_SEARCH(items, 'one', 'test3')))-1), '')
)
FROM cart
| JSON_REMOVE(items, IFNULL(SUBSTR(JSON_UNQUOTE(JSON_SEARCH(items, 'one', 'test3')), 1, LOCATE('.', JSON_UNQUOTE(JSON_SEARCH(items, 'one', 'test3')))-1), '') ) |
|---|
| [{"a": 42, "b": "test4"}] |
SELECT JSON_REMOVE(items, REGEXP_SUBSTR(JSON_UNQUOTE(JSON_SEARCH(items, 'one', 'test3')), '^\\$\\[[0-9]+\\]'))
FROM cart
| JSON_REMOVE(items, REGEXP_SUBSTR(JSON_UNQUOTE(JSON_SEARCH(items, 'one', 'test3')), '^\$\[[0-9]+\]')) |
|---|
| [{"a": 42, "b": "test4"}] |