title: How to order mysql results by column priority?
body: <p>How to order mysql results by column priority?</p>
  
  <p>Example. I have a table of products, the table contains two columns, product name (p.name) and product description (p.desc).</p>
  
  <p>Users should be able to enter keywords to find products in the database.</p>
  
  <pre><code>"p.name LIKE '%keyword%' OR p.desc LIKE '%keyword%'
  </code></pre>
  
  <p>I want the results that match p.name returned first and the p.desc second. </p>
  
  <p>How would I go about achieving this?</p>