How to set a JSON value with JSON_SET MySQL function? [duplicate]

Question

I'd like to insert this JSON value ["Chien", "Chat"] in a JSON, with MySQL8 built-in JSON functions. So I tried with this query but I didn't get the expected output:

UPDATE tasks SET outputFields = JSON_SET(outputFields, '$.checkbox', '["Chien","Chat"]') WHERE id = 6832

This query made this valid JSON:

{"key1": "value1", "key2": "value2", "key3": "value3", "checkbox": "[\"Chien\",\"Chat\"]"}

The expected value is:

{"key1": "value1", "key2": "value2", "key3": "value3", "checkbox": ["Chien","Chat"]}

Is there a function or a work arround for it?

This is almost the same question as this one which I answered: stackoverflow.com/questions/69622166/… — Bill Karwin
– Bill Karwin, Commented Sep 30, 2022 at 14:34

Julien · Accepted Answer · 2022-09-30 15:31:03Z

2

Just use CAST function like this:

UPDATE tasks SET outputFields = JSON_SET(outputFields, '$.checkbox', cast('["Chien","Chat"]' as json)) WHERE id = 6832

answered Sep 30, 2022 at 15:31

Julien

1854 silver badges15 bronze badges

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

Collectives™ on Stack Overflow

How to set a JSON value with JSON_SET MySQL function? [duplicate]

1 Answer 1

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Linked

Related