ISSUE: Mysql converting Enum to Int

This conversion to int in MySQL for enum is only possible:

CAST(CAST(`rating` AS CHAR) AS SIGNED) as value from table WHERE _id = 1

this is what you want

select enum+0 as enum