SQL: Explode an array
===

I have a table that contains JSON objects. Each JSON object contains an array in square brackets, separated by commas.

How can I access any element in the square bracket array, for example "Matt", using SQL?


    {"str":
       [
         1,
         134,
         61,
         "Matt",
         {"action.type":"registered","application":491,"value":423,"value2":12344},
         ["application"],
         [],
         "49:0"
       ]
    }