SELECT * 
FROM `table` 
ORDER BY length( field) , field
işe yarayabilir...