Ordering mixed (alphanumeric) results in mysql

 
Body: 

I had a pretty complicated query that produced a resultset similar to the following:

tid name
20259 8"x10"
20294 10"x20"
20574 5.5"x14"
20581 20"x20"
20350 16"x20"

I wanted to return the results in order of the name so basically the smallest sizes would be shown first.

Here is a simplified query of what I did to achieve what I wanted:

SELECT tid, name
FROM table
ORDER BY name * 1, name

Now I get this resultset:

tid name
20574 5.5"x14"
20259 8"x10"
20294 10"x20"
20350 16"x20"
20581 20"x20"
Tags: 
randomness