MySQL Boolean?

[wildest_jjk]

Hey guys,

So I am trying to create a new database and am going to have a website that allows the user to select tick boxes depending on what they require.

The database will then be searched to see which items have these features. So what is the best way to have either true or false in SQL?

Thanks

 

[JimAroo]

Hey guys,

So I am trying to create a new database and am going to have a website that allows the user to select tick boxes depending on what they require.

The database will then be searched to see which items have these features. So what is the best way to have either true or false in SQL?

Thanks

What about a 'TINYINT' set to 0 or 1?

 

[visibleman]

tinyint(1)/BIT(1), ie: use 0 or 1, usually although I have seen ENUM and Boolean used.