How to set a JSON value with JSON_SET MySQL function?

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:

This query made this valid JSON:

The expected value is:

Is there a function or a work arround for it?


View on Stack Overflow