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

Every DBMS has a completely different toolkit of regex functions. What DBMS are you using? — lemon, May 19 '23 at 11:54

score 0 · Accepted Answer · answered May 19 '23 at 12:42

0

You can try this :

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

Or

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

answered May 19 '23 at 12:42

SelVazi

1 Answers1