counting null data in MySQL

Question

let say i have one table, which have data like:

name       status
bob        single
bob        single
jane       null
tina       null
shane      married

i want if status "single or data null" it means single. so if data empty script can read it as single and can count together. so i can show result like:

Single     Married
3            1

i have tried with this and it doesnt work:

SELECT SUM(IF(status='single',1,0)) AS Single,
       SUM(IF(status='married',1,0)) AS Married
FROM table

Answer 1

If you know there are only 'single', 'married', and null as options, this will work:

SELECT SUM(IF(status!='married',1,0)) AS Single,
       SUM(IF(status='married',1,0)) AS Married
FROM table

Otherwise try

SELECT SUM(IF(status='single' OR status is null,1,0)) AS Single,
       SUM(IF(status='married',1,0)) AS Married
FROM table

Answer 2

SELECT SUM(IF(status='single' OR status IS NULL,1,0)) AS Single,
       SUM(IF(status='married',1,0)) AS Married
FROM table

Answer 3

Use:

SELECT SUM(CASE WHEN x.status = 'single' OR x.status IS NULL THEN 1 ELSE 0 END) AS single,
       SUM(CASE WHEN x.status = 'married' THEN 1 ELSE 0 END) AS married
  FROM (SELECT DISTINCT
               t.name,
               t.status
          FROM YOUR_TABLE t) x