JSON data search in MySQL query

I have a MySQL column with below data:

{
  "ids": [
    "c9cfdecc-dfce-11eb-8c94-0ad691f61ea0",
    "c9cfdecc-dfce-11eb-8c94-0ad691f61ea1",
    "c9cfdecc-dfce-11eb-8c94-0ad691f61ea2"
  ]
}

How can I get records that matched with any requested string?

I tried below queries but no use:

SELECT * from test WHERE JSON_CONTAINS(fragments, '"c9cfdecc-dfce-11eb-8c94-0ad691f61ea1"', '$')

SELECT * from test WHERE JSON_CONTAINS(fragments, '"c9cfdecc-dfce-11eb-8c94-0ad691f61ea1"')

SELECT * from test WHERE JSON_SEARCH(fragments, 'one', "c9cfdecc-dfce-11eb-8c94-0ad691f61ea1")