sql - Replace null with 0 in MySQL

Question

I am getting NULL values in the results of an operation in MySQL.

Is there a way to convert the NULL values into the value 0?

Answer 1

Yes, by using COALESCE.

SELECT COALESCE(null_column, 0) AS null_column FROM whatever;

COALESCE goes through the list of values you give it, and returns the first non-null value.