title: MySQL - word frequency count on long textual field
body: <p>I have a <code>MySQL</code> table, where one of the fields contains a textual description (~5-200 words). </p>
  
  <p>For example <code>Reviews</code>:</p>
  
  <pre><code>Rev_id    Place_id    Stars    Category    Text
  1         12           3        Food       Nice food but a bad dirty place.
  2         31           4        Sport      Not bad, they have everything.
  3         55           1        Bar        Poor place,bad audience.
  </code></pre>
  
  <p>I'd like to make some word count analysis, such as general word frequency count (how many times each of the words has appeared) or top-K words per Category.</p>
  
  <p>In the example:</p>
  
  <pre><code>word    count
  bad     3
  place   2
  ...
  </code></pre>
  
  <p>Is there a way to do it solely in <code>MySQL</code> without involving programming languages?</p>