title: SQL function to get count of how many times string appears in column?
body: <p>Is there a function for MySQL that will count the number of times a string occurs in another string or column? Basically I want:</p>
  
  <pre><code>SELECT
      SUB_COUNT('my word', `my_column`) AS `match_count`
  FROM `table`
  </code></pre>
  
  <p>Thanks!</p>
  
  <p><strong>EDIT:</strong>
  I need to know how many times the string appears in a column for each row in a <code>SELECT</code>.</p>