title: SQL CODE to do: Trending topics equals a twitter
body: <p>If i wants count the matching words in a rows of two tables, with milions of rows, sample:</p>
  
  <p>Table posts, sample:</p>
  
  <pre><code>+----+---------+-----------------------------+
  | ID | ID_user | text                        | 
  +----+---------+-----------------------------+
  | 1  | bruno   | michael jackson is dead     |
  | 2  | thomasi | michael j. moonwalk is dead |
  | 3  | userts  | michael jackson lives       |
  +----+---------+-----------------------------+
  </code></pre>
  
  <p>i want query the words most repeated on the table, limit top 10, the result may be this:</p>
  
  <pre><code>+-------+------------+
  | count | word       |
  +-------+------------+
  | 3     | michael    |
  | 2     | dead       |
  | 2     | jackson    |
  | 1     | j.         |
  | 1     | lives      |
  | 1     | moonwalk   |
  +-------+------------+
  </code></pre>
  
  <p>but i want search only words that repeat more of 10 times, in this case noone word is appear, but if criteria for repetead words is 2, will display only 'michael' and 'dead', but ignore 'is' because i dont want words with less 2 chars of lenght, and the words that a phrase, then i need apear this:</p>
  
  <pre><code>+-------+-----------------+
  | count | word            |
  +-------+-----------------+
  | 2     | michael jackson |
  | 2     | dead            |
  +-------+-----------------+
  </code></pre>
  
  <p>i need a code in mysql that replies the "trending topics" of twitter for posts of my site.</p>