Re: show required row first and then other remaining rows
| From: | Sanjeev N | Date: | Fri, 26 Oct 2007 05:54:23 +0000 |
| Subject: | Re: show required row first and then other remaining rows | ||
| References: | 1 2 3 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-263685@lists.php.net to get a copy of this message | ||
Hi Andrew,
Thanks a lot. it really worked very well.
Sanjeev
On 10/26/07, Andrew Ballard <aballard@gmail.com> wrote:
>
> 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
>
>
--
Warm Regards
Sanjeev
------------------------------------------------
http://www.sanchanworld.com/
http://webdirectory.sanchanworld.com/ - Website
submission
http://webhosting.sanchanworld.com/ - Webhosting
solution provider