Natural Sort in MySQL
Is there an elegant way to have performant, natural sorting in a MySQL database?
natural-sort
How to compare version string (“x.y.z”) in MySQL?
I have firmware version strings into my table (like “4.2.2” or “4.2.16”)
Natural sorting
I have some files that need to be sorted by name, unfortunately I can’t use a regular sort, because I also want to sort the numbers in the string, so I did some research and found that what I am looking for is called natural sorting.