MariaDB Json: Get every key of the whole JSON-column
CREATE TABLE t (j LONGTEXT); INSERT INTO t (j) VALUES (‘{“a”:”1″}’); INSERT INTO t (j) VALUES (‘{“b”:”2″}’); INSERT INTO t (j) VALUES (‘{“c”:”0″, “d”:”0″}’); INSERT INTO t (j) VALUES (‘{“c”:”1″, “d”:”1″}’); SELECT JSON_KEYS(j) FROM t; +————–+ | JSON_KEYS(j) | +————–+ | [“a”] | | [“b”] | | [“c”, “d”] | | [“c”, “d”] | +————–+ […]