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;
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!
We'd like to thank these amazing companies for supporting us