Welcome to the Tweaking4All community forums!
When participating, please keep the Forum Rules in mind!
Topics for particular software or systems: Start your topic link with the name of the application or system.
For example “MacOS X – Your question“, or “MS Word – Your Tip or Trick“.
Please note that switching to another language when reading a post will not bring you to the same post, in Dutch, as there is no translation for that post!
[Solved] SQLite - Natural sort of numeric strings quick and easy
(@hans)
Famed Member Admin
Joined: 12 years ago
Posts: 2869
Topic starter
February 6, 2016 12:16 PM
So I ran into the issue that I wanted to sort numbers followed by a character in a natural order.
Some examples: "480p", "720p", "1080p"
These would sort (as strings): 1080p, 480p, 720p with a normal sort:
SELECT * FROM movies ORDER BY resolution
With a simple trick in your ORDER BY statement you can sort these the right way:
SELECT * FROM movies ORDER BY CAST(resolution AS DECIMAL);
