方案一：select * from ads.ads_hr_idmp_workload_details_api where get_json_string(json_value,'$.field1661586045733') LIKE '%50%' limit 1,500;方案二：SELECT * FROMads.ads_hr_idmp_workload_details_api WHERE json