Your SQL Statement is correct, but it seems you have leading spaces in your values and it will not match your conditions.
Don't save numeric values as in string type column. All these issues due to that. if you can't change your column types to int or some other numeric type do as below. Use Trim function
SELECT name FROM supportContacts
WHERE (trim(is_blocked) <> '0' AND trim(is_active) = '1') .....