title: Order by Field or Find_in_set without IN()
body: <p>I'm building a MySQL query for a search function, now I want to order the outcome in a certain way using an array of ID's.</p>
  
  <p>I've been able to do this by using a piece of MySQL similar to this:</p>
  
  <pre><code>SELECT id, name
  FROM mytable 
  WHERE id IN (77, 3, 123, 1) 
  ORDER BY FIELD(id, 77, 3, 123, 1)
  </code></pre>
  
  <p>But I'm wondering if it's possible to <code>Order by FIELD</code> or by <code>FIND_IN_SET</code> without setting the <code>IN()</code> within the Select query.</p>
  
  <p>I don't want to use the IN() statement because I also expect results that aren't in the array of ID's</p>
  
  <p>Hopefully someone can push me in the right direction,</p>