Custom Sort Order in MySQL
| From: | Steve Vernon | Date: | Sat, 19 Oct 2002 19:46:42 +0000 |
| Subject: | Custom Sort Order in MySQL | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-22522@lists.php.net to get a copy of this message | ||
Hiya,
Just wondering what is the best way to get some data out of a database in cutom order.
They all have grades like A*, A, B, C and some are grade Secret.
If I sort them by grade secret is at the bottom, I would like this at the top. I realise I could
get all the Secret's, then A*, then A as seperate calls, but id prefer to get them all in the
correct order as I belive this will be faster.
Any help would be very much appreciated.
Thanks!
Steve