SELECT * FROM tbl ORDER BY LENGTH(name), name; ----------------------------------------- | id | name | ----------------------------------------- | 2 | Episode 1 | | 1 | Episode 2 | | 4 | Episode 11 | | 3 | Episode 112 | -----------------------------------------