tmp/main*> create table MY_TABLE (ID int not null primary key, MY_BOOL bool not null);
tmp/main*> insert into MY_TABLE values (0, false);
Query OK, 1 row affected (0.00 sec)
tmp/main*> select MY_BOOL from MY_TABLE;
+---------+
| MY_BOOL |
+---------+
| 0       |
+---------+
1 row in set (0.00 sec) 


tmp/main*> update MY_TABLE set MY_BOOL = true where ID in (select 0);
Query OK, 0 rows affected (0.00 sec)
Rows matched: 1  Changed: 0  Warnings: 0
tmp/main*> select MY_BOOL from MY_TABLE;
+---------+
| MY_BOOL |
+---------+
| 0       |
+---------+
1 row in set (0.00 sec) 

mysql> create table MY_TABLE (ID int not null primary key, MY_BOOL bool not null);
Query OK, 0 rows affected (0.01 sec)

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

mysql> select MY_BOOL from MY_TABLE;
+---------+
| MY_BOOL |
+---------+
|       0 |
+---------+
1 row in set (0.01 sec)

mysql> update MY_TABLE set MY_BOOL = true where ID in (select 0);
Query OK, 1 row affected (0.00 sec)
Rows matched: 1  Changed: 1  Warnings: 0

mysql> select MY_BOOL from MY_TABLE;
+---------+
| MY_BOOL |
+---------+
|       1 |
+---------+
1 row in set (0.00 sec)