A tough one - might get better responses on a mysql forum...
SELECT field+0<>0, field+0, field FROM `table` ORDER BY field+0<>0 DESC, field+0, field;
Solution
When I needed to do something similar in the past I just stuck in an extra field for sorting. When a record is saved parse the string and left pad all numbers to 6? digits with zeros. save that in the sort field and job done.
Sign in to participate in this thread!
Laravel
Laravel News
Laracasts
Laravel Podcast