I've got a Java application and also have planned a boolean area to a little(1) area in MySql.

I understand without a doubt that some rows possess the value set to true plus some to false, however, I can not view it in the mysql console - that is annoying whenever you attempt to debug things and understand what's going on.

Can you really configure mysql to show the part(1) fields inside a friendly manner?


mysql> choose overlooked from table

+---------+

 overlooked 

+---------+

         

         

         

         

         

         

         

         

         

         

+---------+

10 rows in set (.00 sec)

select ignored+0 from table;
select cast(ignored as unsigned) from table;