[RESOLVED] ORDER BY question

[shawjames]

I have an easy question (I hope). I am trying to order a query, the field to order will be "sub" (which is an int) but I only want to put sub=0 up front, and all the rest behind but not in numeric order.

right now, I have:

ORDER BY sub, name

so it sorts by sub, and in the event of a tie, it sorts by name.

I would like to have all the sub=0 first sorted by name, then all the sub>0 after, sorted by name.

Can I do this in ORDER BY or do I need a script?

[NogDog]

Here's a thought (untested):

SELECT sub, name, sub = 0 AS sub_sort ORDER BY sub_sort DESC, name