# mysql ifnull并且同时判断空字符

> mysql ifnull并且同时判断空字符 SELECT ifnull(if(length(trim(字段))>0,字段,null),'1') num FROM `tableName` WHERE 1 = 1 and `id` = 'id'

- 原文：https://www.l2qq.com/article/171
- 发布：2022-04-30T06:22:59Z
- 作者：l2qq

---

mysql ifnull并且同时判断空字符
```
SELECT
ifnull(if(length(trim(字段))>0,字段,null),'1') num
FROM `tableName`
WHERE 1 = 1
and `id` = 'id'
```
