title: Need SQL to Sort table based on another list of array
body: <p>I need to get list of item from my table but in sorted order and list must be sorted as below:</p>
  
  <p>Assume I have fields named as "productid" and "productname" and table as below records</p>
  
  <pre><code>1. milk
  2. pizza
  3. boll
  </code></pre>
  
  <p>And I have another list in array such as</p>
  
  <pre><code>boll
  pizza
  milk
  </code></pre>
  
  <p>Now I want to sort table list based on array value and get below list"</p>
  
  <pre><code>3. boll
  2. pizza
  1. mike
  </code></pre>
  
  <p>Is there any SQL which can do what I need? Or I need to do it manually via coding.</p>