title: mysql count word in sql syntax
body: <p>Lets have a simple query:</p>
  
  <pre><code>SELECT myfield
  FROM   mytable
  WHERE  criteria
  </code></pre>
  
  <p>The above query gives us 10 rows of results for example. The field <code>myField</code> is a text field.</p>
  
  <p>My question is this: is it possible to alter the above query and get the total word count of the <code>myField</code> field?</p>
  
  <p><strong>Edited:</strong> By total word count I mean the total word count of all selected fields in query, in all rows</p>
  
  <p><strong>Example</strong></p>
  
  <pre><code>+------------------------------+-------+
  | sentence                     | Words |
  +------------------------------+-------+
  | Hello World                  |     2 |
  | Hello World                  |     2 |
  | Mary had a little lamb       |     5 |
  | Her fleece was white as snow |     6 |
  | Everywhere that mary went    |     4 |
  | Umm, sheep followed her      |     4 |
  +------------------------------+-------+
  </code></pre>