Create JSON index for mysql 8?

Question

MySQL

there is an employees field of type JSON in the following format: [
{
"id": 1,
"name": "Garina Irina Petrovna"
},

{
"id": 2,
"name": "Ivanov Ivan Ivanovich"
}

]

How to add an index to table, by ID?

Tried something like:
CREATE INDEX id_employees_index ON visits employees->>'$.id' AS INT

Answer 1

look

CREATE INDEX id_employees_index ( (JSON_VALUE(visits, '$.id' RETURNING UNSIGNED)) )