Page 1 of 1

Specific ORDER BY

Posted: Mon Jan 22, 2007 3:03 pm
by WanamakerStudios
I have a results set:

Acura
Alfa Romeo
Buick
Chevrolet
Jeep
Subaru
Toyota

And would like to display all of the makes ... but ... would like JEEP to display first. Is there a way I can do a very specific ORDER BY statement to accomplish this?

Posted: Mon Jan 22, 2007 3:09 pm
by feyd

Code: Select all

ORDER BY brand = 'jeep' DESC, brand ASC

Posted: Mon Jan 22, 2007 3:10 pm
by WanamakerStudios
Ok. Thanks. I wasnt sure if I could run a compare in an orderby