Day: April 19, 2011

  • Sorting characters and numbers in mySQL

    So I have a table with a column in this form someColumn 1 A 2 C 3 10 When you ORDER BY someColumn you get result in this order  1,10,2,3,A,C as you can see the number sequence is all messed up, 10 doesn’t go after 1 to fix that you can do ORDER BY (someColum…