title: How to extract the nth word and count word occurrences in a MySQL string?
body: <p>I would like to have a mysql query like this:</p>
  
  <pre><code>select &lt;second word in text&gt; word, count(*) from table group by word;
  </code></pre>
  
  <p>All the regex examples in mysql are used to query if the text matches the expression, but not to extract text out of an expression. Is there such a syntax?</p>