title: Mysql count instances of substring, then order by
body: <p>I have a problem in mySQL that goes as follows:</p>
  
  <ul>
  <li>Count the instances of a substring in a string field in a mySQL database</li>
  <li>Order the results by the number of occurrences of that substring (DESC)</li>
  </ul>
  
  <p>I have never done anything other than rudimentary queries.. I can't find a solution elsewhere.</p>