One of the often used functions in SQL Server is ISNULL, which aids in replacing the null values of a column with an alternative value.
Tag: IFNULL function in MySQL
IFNULL in MySQL
If the expression is NULL, the IFNULL() function returns a specified alternative value. This function returns the expression if it is NOT NULL. This function
Big Data & SQL 