MySQL Forums
Forum List  »  General

select: null or empty values
Posted by: Alexandre Salomé
Date: September 29, 2021 12:12PM

I have a table with many collumns.
when I use a "select" to see theirs values, many of them have a null value.

So, I am using the command to fill this fields;
- example: select if(MyCollumn IS NULL ,"-",MyCollumn ) from table

is it possible change all "null" for "-" in all collumns without declare one by one on select command?



Options: ReplyQuote

Written By
select: null or empty values
September 29, 2021 12:12PM
September 29, 2021 02:21PM

Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.