如何在MySQL中编写可以解析列中JSON数据的查询？

I have a table in MySQL that has a column that store JSON objects. How can I easily run queries that can have some of the JSON fields in the WHERE clause?I have a table in MySQL that has a column that