Converting a string to an integer on the fly (for ordering) in MySQL

Use CAST. For example:

SELECT CAST(1 AS UNSIGNED);