title: How to count the number of occurrence of column values but without GROUP BY (not distinct values) mysql
body: <pre>
  id      title           numbers
  1       chicken         1
  2       meat            1
  3       fish            1
  4       fish            2
  5       meat            2
  6       fish            3
  7       chicken         2
  8       chicken         3
  </pre>
  
  <p>I want to construct the following output as above. Anyone can help me calculate number of occurrence of column values but without <strong>GROUP BY</strong>(not remove same values) , let create "numbers" field same as above , thank</p>
  
  <p>Normal , if use <code>COUNT(*)</code>  :</p>
  
  <pre><code>SELECT COUNT(*) FROM table GROUP BY title
  </code></pre>
  
  <p>But it remove same values :</p>
  
  <pre>
  id      title           numbers
  1       chicken         3
  2       meat            2
  3       fish            3
  </pre>
  
  <p>i want to keep same values , and output like this :</p>
  
  <pre>
  id      title           numbers
  1       chicken         1    
  2       meat            1
  3       fish            1
  4       fish            2
  5       meat            2
  6       fish            3    
  7       chicken         2     
  8       chicken         3     
  </pre>