10-11-2017, 01:42 PM
Fixed all of those, thanks.
Also, in reply to the part of your deleted post referencing that natural sorting in MySQL isn't impossible, I've looked into it. Most, if not all, of the workarounds for it rely on either the length of the string being sorted or the column being entirely numeric. There isn't a way to do it consistently with an unknown data set unless MySQL actually adds in a proper natural sort option.
Also, in reply to the part of your deleted post referencing that natural sorting in MySQL isn't impossible, I've looked into it. Most, if not all, of the workarounds for it rely on either the length of the string being sorted or the column being entirely numeric. There isn't a way to do it consistently with an unknown data set unless MySQL actually adds in a proper natural sort option.