Setting NULL to "0" in MySQL

[rockyracoon]

I want to ORDER BY id DESC

but I get:

NULL
NULL
3
2
1

I want:

3
2
1

NULL
NULL

Any ideas?

[JakesSA]

you can use array_reverse()

[dannys]

Try:

ORDER BY COALESCE(id,0) DESC

That should force MySQL to order null values as if they are '0' - they are still set to NULL though.