title: How to define a custom ORDER BY in MySQL query
body: <p>I need output in following order(firstly, group by last 3 letters and then arrange in order based on the first 3 digits)</p>
  
  <pre>
  ColumnA
  
  001_eng
  004_eng
  002_chn
  003_usa
  </pre>
  
  <p>But order by ColumnA gives me</p>
  
  <pre>
  ColumnA
  
  001_eng
  002_chn
  003_usa
  004_eng
  </pre>
  
  <p>This is just sample data. I have hundreds of entries in this format and the values keep changing everyday. So, specifying all the entries inside the field is not a feasible option.
  I'm not sure of how to use FIELD() in my case.</p>