title: How to retrieve maximum or highest value from table by separate string using mysql
body: <p>I want to retrive highest value from one column of  table  suppose the highest value is 1002 so query will be like this.</p>
  
  <pre><code>1000
  1001
  1002
  
              SELECT max(column1 ) as max_page FROM abc; 
  
      output will be 1002 as highest value but if column data contain string with this valuefor example 
  
      XYZ1000
      XYZ1001
      XYZ1002
  
  
      in this case it is not working of max(column) way so  how to separate string and get maximum value .
  </code></pre>