Re: show required row first and then other remaining rows

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

 



Hi Andrew,

Thanks a lot. it really worked very well.

Sanjeev


On 10/26/07, Andrew Ballard <aballard@xxxxxxxxx> 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

[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