yano3nora
7/1/2017 - 11:02 AM

[mysql: CASE in ORDER BY] use CASE in ORDER BY by mysql. #mysql #sql

[mysql: CASE in ORDER BY] use CASE in ORDER BY by mysql. #mysql #sql

case_in_orderby.sql
content_copyfile_download
ORDER BY 
  CASE 
    WHEN $tableA.s_date = '0' THEN $tableA.r_date
    ELSE $tableA.s_date
  END
DESC