MySQL Forums
Forum List  »  Newbie

Advanced Search
New Topic

Re: ORDER BY that sorts NULLS last
Posted by: laptop alias
Date: May 09, 2008 01:46AM

For future reference, you can use this syntax to put NULLs at the bottom:

ORDER BY IF(ISNULL(my_field),1,0),my_field;

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Written By
Posted
ORDER BY that sorts NULLS last
Reginald Brubaker
May 07, 2008 02:48PM
Re: ORDER BY that sorts NULLS last
Huu Da Tran
May 07, 2008 05:01PM
Re: ORDER BY that sorts NULLS last
Reginald Brubaker
May 07, 2008 05:09PM
Re: ORDER BY that sorts NULLS last
Reginald Brubaker
May 09, 2008 12:43AM
Re: ORDER BY that sorts NULLS last
laptop alias
May 09, 2008 01:46AM


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.