Natural Sort

[Michael Kedl]

> Looking thru the MYSQL archives I see a few people had interest in a "natural
>
> sort" method to sort text fields
> containing numbers.  I to would like this feature.  Has anything been
> done for this?
>
> Currently sorts text like:
> 1200 - A tale of 3 dogs
> 3 bright lights go on
>
> "Should be":
> 3 bright lights go on
> 1200 - A tale of 3 dogs
>
> Thanks,
> Mike