gistfile1.txt

mysql> create table test(bool bit);
Query OK, 0 rows affected (0.06 sec)

mysql> insert into test values(1);
Query OK, 1 row affected (0.00 sec)

mysql> insert into test values(0);
Query OK, 1 row affected (0.00 sec)

mysql> select count(*) from test where bool;
+----------+
| count(*) |
+----------+
|        1 |
+----------+
1 row in set (0.00 sec)