Skip to content

Instantly share code, notes, and snippets.

@iolloyd

iolloyd/truesort.sql

Created February 25, 2014 15:08
Show Gist options
  • Save iolloyd/9210663 to your computer and use it in GitHub Desktop.
Save iolloyd/9210663 to your computer and use it in GitHub Desktop.
Download ZIP
Correctly sort a list where the entries are composed of a mix of letters and numbers
Raw
truesort.sql
SELECT foo, length(foo) l
FROM someTable
ORDER BY order by l, foo;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment