Table design

[sunroof]

Hello,

If I have a lot of fields with values 0/1 in my mysql table which I use for filtering data by that field (ie. WHERE field=1...)

What is the best type for that field for fastest performance?
enum ('0','1') or tinyint?

Thanks

[coopster]

BOOLEAN

[JerryOdom]

I generally use integer/tinyint in case I change my software requirements down the road.