How to extract assigned value from a variable which is part of the json using JSON_EXTRACT funtion in mysql

19 views Asked by At

Hope, I was able to put the question in right way.

here I have a following table in mysql DB.

Table Name: Company

OrgName config
TestCompany {orgld=24,Sector:IT)

How to form a mysql query to extract orgId value present in the config column using JSON_EXTRACT funtion

Please note that I have formed a dummy data, which represent the actual data present in my org's DB

I did try running following query and tried to google, but was with no luck.

select 
  OrgName,
  (JSON_EXTRACT(config,"$.orgid")) as org_id
from
  Company;
0

There are 0 answers