title: How to get substr of max value using select statment in php
body: <p>I am trying to to get sub string from max value searched from database but failed. My string is <code>AB/LAJ/GER/R4/0210/001</code> format where 02 is month and 10 is year and last 000 are increment numbers as records are added. I want to select max year and last 000 max number from database and using this command </p>
  
  <pre><code>"SELECT substr(max(serial), 16) FROM Subscriber WHERE Type= ....."
  </code></pre>
  
  <p>but it display nothing.</p>
  
  <p>Can someone please guide me function?</p>