Need help! SQL order by
Posted: Sat Aug 09, 2008 2:48 pm
Hi all
Is this at all possible:
Ordering content from a database table in alphabetical order, BUT the first value to be set by myself?
So, for example:
Name Age
Frank 21
Tom 32
Andy 21
Owen 43
So in this example I would want to order that data so that Owen is first, and then we order by alphabetic values, so the outcomes would be
Owen (this is the value I want to appear first)
Andy (then the rest are outputted in alphabetical order)
Frank
Tom
This is just an example, I have alot more data then that and they are not names and ages.
Is this at all possible:
Ordering content from a database table in alphabetical order, BUT the first value to be set by myself?
So, for example:
Name Age
Frank 21
Tom 32
Andy 21
Owen 43
So in this example I would want to order that data so that Owen is first, and then we order by alphabetic values, so the outcomes would be
Owen (this is the value I want to appear first)
Andy (then the rest are outputted in alphabetical order)
Frank
Tom
This is just an example, I have alot more data then that and they are not names and ages.