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;