Q:

Sort String Numbers

I have a column of type varchar that stores many different numbers.  
Say for example see the picture 
It should short as 
12-1
12-13
12-105
12-127
12-168
Thanks

A:

1You can try something like that:
SELECT *, SUBSTRING_INDEX(row_name, '-', 1) as some_sort
FROM table_name
ORDER BY some_sort

So i guess (not tested, but idea in that way) : 
12-34,12-46,12-95,12-135...etc
But question quality is low, so i can only guess what u want to do.