yano3nora/case_in_orderby.sql

Created July 1, 2017 11:02

Star () You must be signed in to star a gist
Fork () You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/yano3nora/c9b5d2b96c95127a8d01afd2801dd125.js"></script>
Save yano3nora/c9b5d2b96c95127a8d01afd2801dd125 to your computer and use it in GitHub Desktop.

Download ZIP

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

Raw

case_in_orderby.sql

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

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment