Removing integer from JSON column using JSON_REMOVE

Question

I would like to remove the number 6 from the column access (type json) without knowing its array location.

Example access row 1: [1, 2, 3, 4, 5, 6, 7, 8, 9]

CREATE TABLE example (
    id int NOT NULL AUTO_INCREMENT,
    access json NOT NULL,
    PRIMARY KEY (id)
);

INSERT INTO `example` (`access`) VALUES ('[1, 2, 3, 4, 5, 10, 20, 30]');

SELECT * FROM `example`;

SELECT JSON_SEARCH(`access`, 'one', '30') from `example`;

The JSON_SEARCH doesn't return any results.

Tom Chapman · Accepted Answer · 2020-09-20 02:32:57Z

0

You've probably moved on but should anyone else find themselves in the same position as I, trying to search arrays of integers... JSON_SEARCH doesn't support the function.

https://bugs.mysql.com/bug.php?id=79233

answered Sep 20, 2020 at 2:32

Tom Chapman

4327 silver badges15 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Removing integer from JSON column using JSON_REMOVE

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related