mysql CAST enum datatype to decimal
I noticed that we can’t convert ENUM datatype to decimal directly. What I do is CAST enum data to Char first and then convert to Decimal as below
SELECT CAST(CAST(myenum AS CHAR) AS DECIMAL(10,2))
Please share if you have better solution