Re: Specific order by MySQL statement
| From: | Constantin Brinzoi | Date: | Mon, 07 Nov 2005 12:00:36 +0000 |
| Subject: | Re: Specific order by MySQL statement | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-40614@lists.php.net to get a copy of this message | ||
One possibility is to use codes for this filed, such as:
10 for Current;
20 for Completed;
30 for Withdrawn;
40 for Transferred.
a.s.o.
If you will discover other "states" of the field you can "insert" them
apropriatelly (if you want Canceled state to be inserted and to be
displayed last put the code 45 for it).
Best regards,
Aurel
On Mon, 2005-11-07 at 11:47 +0000, Adrian Bruce wrote:
> Hi
>
> I am trying to get results from a MySQL query in a specific order, just
> using ASC or DESC will not work.
>
> For Example I have a field that can contain 4 possible values:
> 'Current', 'Completed','Withdrawn' or 'Transferred', I
> would like to
> order the results specifically like:
>
> Current
> Completed
> Withdrawn
> Transferred
>
> Is there any way i can do this using MySQL? Any help will be much
> appreciated.
>
> Thanks, Ade
>