‘{“topics”: [“Fintech”, “Artificial Intelligence”, “Market Research & Consumer Insights”],
“companies”: [{“name”: “TKO Group”, “idCbiEntity”: 1091583}, {“name”: “All Elite Wrestling”, “idCbiEntity”: 1058641},
{“name”: “New Japan Pro Wrestling”, “idCbiEntity”: 276499}]}’
in this i want extract “name” in the companies tag in to a single column
select
JSON_EXTRACT_PATH_TEXT(‘{“topics”: [“Fintech”, “Artificial Intelligence”, “Market Research & Consumer Insights”],
“companies”: [{“name”: “TKO Group”, “idCbiEntity”: 1091583}, {“name”: “All Elite Wrestling”, “idCbiEntity”: 1058641},
{“name”: “New Japan Pro Wrestling”, “idCbiEntity”: 276499}]}’,’companies’, ‘name’,true);
tried this, But getting null values as result
satya prakash Gubbala is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.