aaronmcadam/ordering a list of items not alphabetical order.sql

Created September 16, 2010 14:53

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

Download ZIP

ordering a list of items but not in alphabetical order

Raw

ordering a list of items not alphabetical order.sql

SELECT `Name`, `Rating`, `City`, `Country`, `Displayed`, REPLACE(REPLACE(REPLACE(`Rating`,'Gold','1'),'Silver','2'),'Bronze','3') as `ratingNum` FROM `table` WHERE `Displayed` = 'Yes' ORDER BY `ratingNum`,`Name` ASC

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