title: Mysql query order starts with then contains
body: <p>How to select and ordered all results that start with <code>LIKE 'a%</code> and then contains <code>LIKE '%a%'</code> with a limit of e.g. 3.</p>
  
  <p>For example the following dataset: b, aab, baa, cad, ccc, bb, ac.
  The desired result is to get aab, ac, baa.
  (If the limit is 2, no items for contains should be returned.)</p>