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
– lemon, Commented May 19, 2023 at 11:54

SelVazi · Accepted Answer · 2023-05-19 12:42:23Z

0

You can try this :

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

Or

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

answered May 19, 2023 at 12:42

SelVazi

16.2k2 gold badges19 silver badges35 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1