Untitled query #87212

SQL

SET @json_document = '
[
    { "ns_id": 0, "ns_name": ":"},
    { "nd_id": 1, "ns_name": "Talk:"},
    { "ns_id": 2, "ns_name": "User:"},
    { "nd_id": 3, "ns_name": "User talk:"},
    { "ns_id": 4, "ns_name": "Wikipedia:"},
    { "nd_id": 5, "ns_name": "Wikipedia Talk:"},
    { "ns_id": 6, "ns_name": "File:"},
    { "nd_id": 7, "ns_name": "File talk:"},
    { "ns_id": 8, "ns_name": "MediaWiki:"}, { "nd_id": 9, "ns_name": "MediaWiki talk:"}, { "ns_id": 10, "ns_name": "Template:"},
    { "nd_id": 11, "ns_name": "Template talk:"},
    { "ns_id": 12, "ns_name": "Help:"},
    { "nd_id": 13, "ns_name": "Help talk:"},
    { "ns_id": 14, "ns_name": "Category:"},
    { "nd_id": 15, "ns_name": "Category talk:"}
]
';

SELECT * FROM JSON_TABLE(@json_document, '$[*]'
    COLUMNS (
    id INT PATH '$.ns_id', 
    name VARCHAR(50) PATH '$.ns_name'
    )
) AS json_table
WHERE json_table.id > 8
;
SQL

Checking query status...
