SELECT CASE WHEN column_name THEN 1 ELSE 0 END AS column_name FROM table ...