Vanilla 1 is no longer supported or maintained. If you need a copy, you can get it here.
HackerOne users: Testing against this community violates our program's Terms of Service and will result in your bounty being denied.

Advanced MySQL question (order by numeric part of string)

edited June 2009 in Vanilla 1.0 Help
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
Sign In or Register to comment.