If null, 0, else 1

I'm having a brain fart... how do I do:

SELECT col FROM table

and if col is NULL, I want a 0, otherwise I want a 1.

SELECT IFNULL(col, 0) as col

edit:

On second thoughts you prob need

SELECT IF(col IS NULL, 0,1) as col

That gives me the column's value, or a 0, I want either a 1 or 0, like a boolean of if the field has a value or not, not the actual value.

What I really need is Y/N.

SELECT IFNULL(group_id, 0) FROM group

Gave me

1,2,3,4,5,6,7 etc.

Edit: thank you - the second was exactly it. I just couldn't remember if there was a shorthand for it, but IF is what I needed.

see my edit