根据key存不存在查询json

select *  from  table where value->'key' != 'null';

原文地址:https://www.cnblogs.com/flintlovesam/p/5502129.html