boolean data type

[boywonder]

I'm currently using ENUM ('0','1') to store a value that will always be 0 or 1.
Question is there a boolean (bit) data type in mysql, or if not is there a more efficient way to store this? Thanks.

[mordred]

Not that I know of. Another way would be to use a TINYINT column with length 1 if you want to cut down on storage size, but the ENUM solution should work fine even for long queries.

[boywonder]

Thanks mordred - :)