Is it possible to process json directly in mysql?

Question

MySQL

Good day everyone.
I have a field in the table containing data in json format
. Is there any method for processing this data directly in mysql - for example, selection by condition or am I thinking stupid and should I process them in php?

Answer 1

Is there any method to process this data directly in mysql

If you replace mysql with postgresql, then there is a minimum set of tools for sampling.
In general, no, mysql cannot do this (and thank God). If you want to make a selection, either store the data in a normalized form, or connect some elastic to organize data aggregations and select them.

Answer 2

It is possible to store in xml, in it it is possible.