通過
is null
或
is not null
可以來判斷空字段。
空字段篩選過程示範:
select image_src, pk_group from sm_appmenuitem where image_src is null;
![](https://img.laitimes.com/img/__Qf2AjLwojIjJCLyojI0JCLicmbw5yMiRWZ2cTY2UjN5kTZ2cTOzkTY0M2NhNmZ0MWMyEWNm9CX5d2bs92Yl1iclB3bsVmdlR2LcNWaw9CXt92Yu4GZjlGbh5yYjV3Lc9CX6MHc0RHaiojIsJye.png)
非空字段篩選過程示範:
select image_src, pk_group from sm_appmenuitem where image_src is not null;
喜歡的點個贊❤吧!