Correct syntax to query JSON_SET in MYSQL in Node

Question

I need to set/update a JSON array in a MYSQL table from Node and I have this query which throws an Invalid JSON path expression error. For example, I want to find the object with key 2022-01-03 and if it exists, update its value to O 08:00

UPDATE allemployees SET schedule = JSON_SET(schedule, '$.2022-01-03', 'O 08:00') WHERE name_cyr = 'John Doe' 

The JSON in my table is as follows:

[{"2022-01-03": "H 08:00"}, [{"2022-01-04": " H 08:00"}] ]

Answer 1

UPDATE allemployees
SET schedule = JSON_SET(schedule, '$[0]."2022-01-03"', 'O 08:00') 
WHERE name_cyr = 'John Doe';

https://dbfiddle.uk/?rdbms=mysql_8.0&fiddle=2c59600049b4dfc1675c444a6da578bb

1. Path"2022-01-03" contains dashes and must be enclosed in double quotes.

2. The value to be set is not the superior value, but the component of the clear array element.