egulhan/sorted-items-with-in-operator.sql

Created April 15, 2015 12:10

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

Select an option

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

Download ZIP

Get sorted items while using IN operator

Raw

sorted-items-with-in-operator.sql

	select *
	from items
	where item_id in (1,3,5,7,2,4,6,8)
	order by field(item_id, 1,3,5,7,2,4,6,8)

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