Welcome to ShenZhenJia Knowledge Sharing Community for programmer and developer-Open, Learning and Share
menu search
person
Welcome To Ask or Share your Answers For Others

Categories

I have four string columns feed1,feed2, feed3, feed4 which have 30 % of NULL values and the requirement is to concatenate four columns with a comma. When I used CONCAT_WS it is giving numbers instead of string values and it is showing ,,, if all the columns are NULL instead of NULL. Please let me know how to do handle the NULL values and concatenate four columns into one column.

Thanks, Madhu


与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
thumb_up_alt 0 like thumb_down_alt 0 dislike
830 views
Welcome To Ask or Share your Answers For Others

1 Answer

You can use IFNULL function like below,

select CONCAT_WS(',',IFNULL(feed1,'NULL'),IFNULL(feed2,'NULL'),IFNULL(feed3,'NULL'),IFNULL(feed4,'NULL')) as 'value' from TABLE;

To learn more on IFNULL click this.


与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
thumb_up_alt 0 like thumb_down_alt 0 dislike
Welcome to ShenZhenJia Knowledge Sharing Community for programmer and developer-Open, Learning and Share
...