I have this: ---Quote--- SELECT itemid, hits, title, params FROM `items` WHERE hits= 8 ORDER BY hits ASC, params DESC ---End Quote--- I need the data to sort by hits and then any NULL params are at the bottom of the list. I know...
I have this:
Quote:
SELECT itemid, hits, title, params FROM `items` WHERE hits= 8 ORDER BY hits ASC, params DESC
I need the data to sort by hits and then any NULL params are at the bottom of the list. I know the above statement is wrong and ordering params by desc won't put them at the bottom. But I'm not sure how to do this.