Wednesday, November 28, 2018

MySQL case when in order




Example of  using CASE WHEN ... ELSE... END ) in ORDER BY in MySQL
                 ORDER BY
                    (CASE WHEN     ranks.`EndDate` IS NULL OR ranks.`EndDate`='0000-00-00' OR TRIM(ranks.EndDate)='' THEN '9999-12-20'
                     ELSE                  
                     ranks.`EndDate` END)
DESC,

No comments:

Post a Comment