Skip to content

Instantly share code, notes, and snippets.

@shivenigma

shivenigma/order by ASC but some value at top

Created May 11, 2015 12:31
Show Gist options
  • Save shivenigma/566a306ed6e05f4dd8bf to your computer and use it in GitHub Desktop.
Save shivenigma/566a306ed6e05f4dd8bf to your computer and use it in GitHub Desktop.
Download ZIP
when ordering using mysql, bringing specific values to the top of the list like country dropdown us at the top
Raw
order by ASC but some value at top
SELECT * FROM stores ORDER BY country = "us" DESC, storeId
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment