How to search in MySQL 5.7 by JSON type field?

Question

MySQL

How to correctly form a query to the database to find all records where there is res with id=4
example field value
{
"res": [{"id": 1, "count": 79.307}, {"id": 2, "count ": 64.844}, {"id": 3, "count": 5.643}, {"id": 4, "count": 26.166}]
}

Answer 1

Read here:
dev.mysql.com/doc/refman/5.7/en/json-search-functi...
This is without going into why you need to store json

Answer 2

If you are using a relational database, use a relational data schema.