Count Occurances of Different Enum Values in One Query

Databases
2

indeed, in order by their actual values (0,1,2,3…)

best advice i can offer is never use the dreaded, evil ENUM (i’ve been saying this here in sitepoint for almost 10 years)

here’s an article – http://komlenic.com/244/8-reasons-why-mysqls-enum-data-type-is-evil/

any chance you can change the table?