If condition in select query

select email from mailing list

This is the query i want to use if condition. I have a column in mailing list as 开发者_StackOverflow社区unsub. If this unsub is true the email should null in the selected result otherwise the email will be the selected result

select case unsub when true then null else email end as email,....
from ...

see the docs for more examples.