CODE EXAMPLE FOR SQL

how covert into int in maria db

SELECT enum_col FROM tbl_name 
ORDER BY CAST(enum_col AS CHAR);