Support the ongoing development of Laravel.io →
foofighter2
posted 9 years ago
Eloquent
Last updated 2 years ago.
0
elite123
replied 9 years ago

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;
0
kpzani
replied 9 years ago
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.

0
foofighter2
replied 9 years ago

Thanks @kpzani; that's what I ended up doing. Not the cleanest, but it gets the job done!

0

Sign in to participate in this thread!

Eventy

Your banner here too?

foofighter2 foofighter2 Joined 23 Feb 2015

Moderators

We'd like to thank these amazing companies for supporting us

Eventy
Fathom
Forge
Envoyer
Beyond Code
Skynet Technologies
BairesDev
Dotcom-monitor
N-iX

Your logo here?

Laravel.io

The Laravel portal for problem solving, knowledge sharing and community building.

Laravel.io

Forum Articles Pastebin

Socials

X Twitter GitHub

The community

Laravel Laravel Laravel News Laravel News
Laracasts Laracasts Laravel Podcast Laravel Podcast
© 2024 Laravel.io - All rights reserved.
Terms of service Privacy policy Advertise