查询 extend_info 里没有 content_id 的记录,sql语句

        select *
	from table_name
	where dt between '2020-03-29' and '2020-03-30'
	and coalesce(extend_info['content_id'],get_json_object(extend_info['query'],'$.content_id')) is null
原文地址:https://www.cnblogs.com/cag2050/p/13227197.html