Advanced MySQL question (order by numeric part of string)
Hi,
The problem is I have to select the rows where some varchar col is equal to "sometext--123" where 123 is any continuous number, and I have to order the results by that number instead of 123. So I have to retrieve all rows that satisfy the pattern, then take that number in the string, and then sort the results by that number. Any solutions? thanks
0