'I want to use an object inside a json array as search criteria in mysql8

I have a JSON array in a table of MySQL database such as

[
  {
    "key": 1,
    "value": "job"
  },
  {
    "key": 2,
    "value": "2022-05-11 18:00:00"
  },
  {
    "key": 3,
    "value": 100
  }
]

how can i search for the criteria "key=3 and value >= 100" ?

mysql json mysql-8.0

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Solution	Source