An application I created used a lot of MySQL ENUMS. They are kind of useful, in that the value of an ENUM column does not need a lookup. The downside is that it lead to a lot of string comparisons in the code, and this became a prime suspect when performance degraded. However a colleague [...]