MariaDB JSON: contains specific value in any sub attribute
I’m having a JSON like: {"a": {"z":true,"y":false}, "b": {"z":false,"y":false} }.
I need to obtain in MariaDB if there is any (sub) attribute in this JSON that contains the value “true”.
I’m having a JSON like: {"a": {"z":true,"y":false}, "b": {"z":false,"y":false} }.
I need to obtain in MariaDB if there is any (sub) attribute in this JSON that contains the value “true”.