How to check json format?

Question

PHP

Hello. I am working with medoo library for database (mysql).
The table has fields that contain data in json format, this json is a list of employees (it can be anything), how can you use medoo to check if there is, for example, this json "Vasya", I'm looking for something like has , I repeat, I want somehow immediately check for the presence of a certain "employee" in the cell, without first making a selection, and then run php in a loop and check whether there is such a functionality in this lib, he searched it all and did not see this. Also I ask to prompt who uses what libraries for work with bases?

Answer 1

either it has nothing to do with it, not even considering that you took the simplest one to solve the most basic things.
https://dev.mysql.com/doc/refman/5.7/en/json.html
JSON in mysql is relatively recent.
https://dev.mysql.com/doc/refman/5.7/en/json-search...