Given this data: I’ve tried several of the common natural sorting methods for mysql, but they won’t sort these in a natural descending way, like: For example: Answer Assuming the parts on either side of the – are limited to 2 digits and 5 digits respectively, you can extract the two numeric values using SUBSTR (and LOCATE to find the