I am very confused about this question. The problem is that I know I can use the COALESCE function, but how? Because there are two columns here, State and Fax.
1
0
0
You can use if null
select id,ifnull(state, '') as state ,ifnull(fax, '') as fax from customer
![[Web front-end] Node.js quick start](https://img.php.cn/upload/course/000/000/067/662b5d34ba7c0227.png)
