json_unquote(json_extract(`ad`.`data`, '$.banks.works[0].company_name')) AS `work`SELECT JSON_EXTRACT(my_column,'$[*].ddi') as ddi FROM my_table
json_unquote(json_extract(`ad`.`data`, '$.banks.works[0].company_name')) AS `work`SELECT JSON_EXTRACT(my_column,'$[*].ddi') as ddi FROM my_table