查询 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

posted on 2020-07-02 21:23  cag2050  阅读(312)  评论(0编辑  收藏  举报

导航