By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE t
( `value` TEXT)
;
INSERT INTO t
( `value`)
VALUES
('[{"keyId": "aded5b0107bb5a936604bcb6f", "keyNames": ["abc1, abc2"], "keyDesc": "test"}]')
SELECT
j.keyId, j.keyNames, j.keyDesc
FROM t, JSON_TABLE(value, '$[*]'
COLUMNS(
keyId TEXT PATH '$.keyId'
,NESTED PATH '$.keyNames[*]' COLUMNS (keyNames varchar(10) PATH '$')
, keyDesc TEXT PATH '$.keyDesc'
)
) AS j;
| keyId | keyNames | keyDesc |
|---|---|---|
| aded5b0107bb5a936604bcb6f | abc1, abc2 | test |