title: Sorting an Alphanumeric value mysql
body: <p>I want to find the max value in a column.</p>
  
  <p>Column values are,
  E00004, 
  A00005, 
  B00011, 
  H-00001, 
  E2100112, 
  EFQ20098, 
  ESSF20003 </p>
  
  <p>I just want to sort the values by their number, Dont mind about the alphabets. It have to be like this, <strong>I'm using MYSQL</strong></p>
  
  <p>E2100112, 
  ESSF20003, 
  EFQ20098,
  B00011,
  A00005,
  E00004,
  H-00001 </p>