Re: Custom Sort Order in MySQL
| From: | Ignatius Reilly | Date: | Sat, 19 Oct 2002 20:05:06 +0000 |
| Subject: | Re: Custom Sort Order in MySQL | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-22525@lists.php.net to get a copy of this message | ||
You can use an auxiliary lookup table:
FK_mygrade rank
------------ -----
Secret 1
A+ 2
...
Now join this table to your SELECT query on FK_mygrade, add 'rank' to the
SELECT items,
and ORDER BY rank
HTH
Ignatius
____________________________________________
----- Original Message -----
From: "Steve Vernon" <steve@extremewattage.co.uk>
To: <php-db@lists.php.net>
Sent: Saturday, October 19, 2002 9:46 PM
Subject: [PHP-DB] Custom Sort Order in MySQL
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