Which is better to use enum() or boolean() field type?

Question

MySQL

If there are more than 3 statuses, then it is clear that enum should be used, but what are the differences if there are only 2 statuses? What type of field is preferable to use?

Answer 1

Depends...
If it is really logical fields ala is/is not present it is possible to use bool. If these are just 2 values ​​clearly not related to true / false, it is better to use enum, especially if later the logic may change and you need to change the type.

Answer 2

I am using tinyint.

Answer 3

if the answer options are "yes" and "no", then a boolean type is fine, if there is something akin to "white" and "black", then I would rather use an enum...