Regexp instruction in SQL

Question

After applying function GET_JSON_OBJECT(features, '$.field') I get the values:

{10:3,300:286}
{300:86}
{300:3,50:1}

How to get the value after 300 then?

Needed result is

286
86
3

Answer 1

You can try this :

GET_JSON_OBJECT(features, '$.field.300') 

Or

 GET_JSON_OBJECT(features, '$.field."300"')