Results 1 to 12 of 12
Thread: Ordering by content of record
Nov 10, 2010, 12:14 #1
- Join Date
- Mar 2002
- 0 Post(s)
- 0 Thread(s)
Ordering by content of record
I am kind of getting addicted to SPF as every question I ask always gets a quick answer... I just wish the forums covered more topics
But let's get to my question. Let's imagine I have a database with all kinds of "monitors'" data. One of these pieces of data is the color of the monitor. Is there a way that in any search I do I can make sure the "black" monitors are always ordered first?
Let's assume a couple things:
1. there is a black model for every model
2. there are all kinds of colors so that a simple "ORDER BY color ASC" will not work
3. searches always output more than one model and the black model must appear just before the other colors of the same model
Thanks in advance for your patience.
Last edited by frodo; Nov 10, 2010 at 12:17. Reason: Added clarification