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, you can't reply to this topic. It has been closed.

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.