title: searching MySQL for most phrase occurrence
body: <p>I am trying to search an entire table and return the most occurring phrases (up to three words) within a long string. I believe I could use fulltext search, but I am not matching against anything...</p>
  
  <p>table</p>
  
  <pre><code>I like Iron Man 3 so much
  Iron Man 3 sucked alot
  Iron Man really saved the day
  I like cats
  cats are cool
  </code></pre>
  
  <p>result</p>
  
  <pre><code>Iron Man
  Iron Man 3
  cats
  </code></pre>
  
  <p>query</p>
  
  <pre><code>SELECT *
      FROM table
      WHERE substring(text, up to 3 words) OCCURS MOST
      ORDER BY OCCURRENCE DESC
  </code></pre>