extract JSON field in mysql table

extract_vm_info.sql

select ddn.properties->>'$.server.name' as os_hostname,
 ddni.external_name,
 ddni.host_instance_name,
 ddni.name,
 ddni.runtime_properties->>'$.ip' as main_ip
 from deployment_details_node ddn,
 deployment_details_node_instance ddni,
 deployment dp
 where dp.tenant_id = 'bocomm' 
 and dp.deleted =false 
 and ddn.`type` like '%Server'
 and ddn.deployment_id = dp.id 
 and ddni.deployment_details_node_id = ddn.id;