I am very confused about this question .The thing is know that I can use COALESCE function for this but how ?Because there are 2 columns here ,State and Fax

CodePudding user response：

You can use if null

select id,ifnull(state, '') as state ,ifnull(fax, '') as fax from customer