huangzhuolin/index.sql

Created September 14, 2018 02:53

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/huangzhuolin/3e52ea807986b0b1508ea6930819ba5e.js"></script>
Save huangzhuolin/3e52ea807986b0b1508ea6930819ba5e to your computer and use it in GitHub Desktop.

Download ZIP

[mysql select case when] #mysql

Raw

	select case field_a
	when '1' then 'cat'
	when '2' then 'dog'
	else 'unknown'
	end
	from my_table;

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