Re: show required row first and then other remaining rows

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

To: php-general@xxxxxxxxxxxxx
Subject: Re: show required row first and then other remaining rows
From: "Andrew Ballard" <aballard@xxxxxxxxx>
Date: Thu, 25 Oct 2007 14:57:21 -0400
In-reply-to: <4720e446.1437720a.6de9.0de2@xxxxxxxxxxxxx>

This should work:

ORDER BY CASE WHEN id = 3 THEN 0 ELSE 1 END, name

Andrew

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Follow-Ups:
- Re: show required row first and then other remaining rows
  - From: Sanjeev N

References:
- Comment / Reply function
  - From: Merlin
- show required row first and then other remaining rows
  - From: Sanjeev N

Prev by Date: Re: show required row first and then other remaining rows
Next by Date: RE: mail from
Previous by thread: Re: show required row first and then other remaining rows
Next by thread: Re: show required row first and then other remaining rows
Index(es):
- Date
- Thread

[Index of Archives] [PHP Home] [Apache Users] [PHP on Windows] [Kernel Newbies] [PHP Install] [PHP Classes] [Pear] [Postgresql] [Postgresql PHP] [PHP on Windows] [PHP Database Programming] [PHP SOAP]

Powered by Linux