I have a column that has strings of the following type:
I try to sort the column based on the numerical part of the data.
I tried the following:
SELECT * FROM the_table ORDER BY CAST(RIGHT(data,2) AS UNSIGNED);
But this does not work. It places
Jones 100 as the first entry etc.
What am I doing wrong?