1// I use mysql 5.7 and so JSON_CONTAINS can be easily used like this:
2
3SELECT JSON_CONTAINS(
4                '[{"id": "24av","name": "she"},{"id": "e0c2", "name": "another_she"}]', 
5                JSON_OBJECT('id', "e0c2")
6                );