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?

Regards

Aecs

Options: ReplyQuote


Subject
Written By
Posted
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.