Select json. Select where json. select with json

Select WHERE json. Json field in mysql.

SELECT JSON_EXTRACT(field, "$.category.name")
FROM table WHERE JSON_EXTRACT(field, "$.category.name") = 'xxxx'