mysql order string by number

This can be accomplished using one select statement. It involves using the REPLACE, LEFT and CAST functions. Say we have this string: 1. This is no. 1 9. This is no. 9 10. This is no. 10 If you use