I want to have a control to hide some products contemporarily on the website. I thought that it is easier to make the change on the database than to change the sql and to load the page again.

I added a new column by:

```
ALTER TABLE product ADD hide BINARY NULL;

```

It created a TINYINT(1) column. If I make some products 1 to hide, then make some of them 0 again to show, I will have a table with a hide column like:

```
*hide*
NULL
0
1

```

When I query by:

```
SELECT * FROM product WHERE hide <> 1;

```

it shows only 0's, but not NULL's.
When I changed the column into BIT, it turned into BIT(1), the same query results in the same.

Logically, if something is defined as 0 or 1, there is not another option. That's why you use binary. A third option is not logical.

To comply with the definitions, is the only way to write as below?

```
SELECT * FROM product WHERE hide <> 1 OR hide IS NULL;

```

(using MySQL 5.6.17)

Question-2: How do you hide a product temporarily? In a different way?