On Mon, 4 Oct 2004 11:03:13 +0200, Martijn Tonies <m.tonies@stripped> wrote:
> > I have two date fields (1095689105) in mysql. One is Creation date and
> > other is Modify date. If news is not modified its value is 0. How can I
> > sort my news so modify date is more important (if exists) than creation
> > date?
> What about an ORDER BY with a CASE statement that uses
> the CreationDate if ModifyDate = 0 and ModifyDate if it's <> 0.
> With regards,
ORDER BY if(ModifyDate = 0,1, ModifyDate), CreationDate