Re: confused by mysql command:select * ..order by if(death is null,0,1),death;

Fabian Schmidt <[email protected]> Fri, 4 Aug 2006 10:30:56 +0200 (CEST)

Newsgroups	gmane.comp.db.mysql.java
Message-ID	<Pine.GSO.4.61.0608041028450.13671@doesen5.informatik.uni-leipzig.de>

Am 03.08.06 schrieb lanxiazhi:

> select first_name,last_name,death from president
> order by
>  if(death is null,0,1),
>  death desc;

I suppose you look for:

  order by
   if(death is null,0,1) DESC,
   death desc;


Ciao,

Fabian.


-- 
MySQL Java Mailing List
For list archives: http://lists.mysql.com/java
To unsubscribe:    http://lists.mysql.com/[email protected]