Re: Order by in Select

I think a join can solve this: Select * from table where id not in(select_id) + Select * from table where id = select_id . Don't ? Jayme www.conex.com.br/jjeffman -----Mensagem original----- De: Bernie Huang <bernie.huang@ec.gc.ca> Para: PHP Database <php-db@lists.php.net> Data: Quinta-feira, 20 de Julho de 2000 13:53 Assunto: [PHP-DB] Order by in Select >Hello, > >I have a list of id's that I need to sort and fetch. > >eg; 1,3,6,5,4,3,4,5,6,7,5,4,2 > >Select id >>From table >Order By id Asc; > >it becomes like: 1,2,3,3,4,4,4,5,5,5,6,6,7 > >What can I add to the above sql statement so that is fetches the >specified id first in a sorted list? > >eg: if ($specified_id=5); >I want: 5,5,5,1,2,3,3,4,4,4,6,6,7 > >I could have done it in two different sql statements where one fetches >specified_id and the other fetches and sorts others, but I want to be >able to do it in one sql statement to reduce time. > >Any ideas? Thank you! > > >- Bernie >