COUNT(CASE WHEN A LIKE 'Marvin%' THEN 1 END)
SELECT COUNT(IF( `column` = 1, `column`, NULL)) as total