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!
The Laravel portal for problem solving, knowledge sharing and community building.
The community