mysql json类型

select service_content_info,json_type(service_content_info),json_extract(service_content_info,'$.*'),service_content_info->"$.k1" from ful_ky_sample_info where service_content_info is not null and json_extract(service_content_info,'$.*') like "%10%";