Performing data manipulation like this in every query is not efficient. It would be better if you split the values apart and stored each part in a separate column, with an appropriate string/integer data type. You can then directly order the values as expected.
1 Like