MySQL Forums
Forum List  »  Newbie

Re: if statment in ORDER BY
Posted by: Roland Bouman
Date: August 02, 2005 12:51PM

ORDER BY A
, ifnull(B,C)
, C

So, if B is not null, order by B, but if it is null, plug in C.

Options: ReplyQuote


Subject
Written By
Posted
August 02, 2005 09:04AM
Re: if statment in ORDER BY
August 02, 2005 12:51PM
August 03, 2005 02:35AM
August 03, 2005 02:52AM
August 03, 2005 02:59AM
August 03, 2005 03:19AM
August 03, 2005 03:45AM
August 03, 2005 04:40AM
August 03, 2005 04:09AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.