MYSQL: replace null with 0?

Question

if i get a null table cell in my results, is there a way to convert it to 0? but just for the results? not actually modifying the data?

Answer 1

There is the COALESCE method which return the first non-null parameter, in your case :

COALESCE(field, 0)

But you can use this if you want more :

COALESCE(field1, field2, 0)

Answer 2

You don't mention which DBMS you're using, but at least in SQL Server (and probably others), you can use 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.

Answer 3

MySQL:

SELECT COALESCE(Mycolumn, 0);