Results 1 to 5 of 5
Thread: Order by field and then count
Nov 28, 2012, 06:55 #1
- Join Date
- Jan 2005
- 0 Post(s)
- 0 Thread(s)
Order by field and then count
I have some rows that are ordered by a count DESC. That's fine, but I want to "pin" some specified fields to the top of the results. This field is empty for most results, but there are a few that have the date: first, second, third...
ORDER by FIELD (rating, 'first', 'second', 'third'), count DESC
This doesn't work! How can I get the results to show the 'first', 'second', 'third' first and then order the rest by count DESC?