title: Counting how many times each unique element appeared in the table
body: <p>I have a MySQL table called <code>key_uniqueWord</code>. This is how it looks like.</p>
  
  <p><img src="https://i.stack.imgur.com/TlWGk.png" alt="enter image description here"></p>
  
  <p>This is how the table is created..</p>
  
  <pre><code>CREATE TABLE `key_uniqueword` (
   `p_id` int(11) NOT NULL,
   `word` varchar(45) NOT NULL,
   `uniqueWordCount` int(11) NOT NULL,
   KEY `conv4` (`uniqueWordCount`,`p_id`,`word`)
  ) ENGINE=MyISAM DEFAULT CHARSET=latin1
  </code></pre>
  
  <p>I can get the list of each unique individual record in <code>word</code> column from the following command.</p>
  
  <pre><code>SELECT DISTINCT `word` from `key_uniqueword`
  </code></pre>
  
  <p>I can check how many times a "particular" individual element in <code>word</code> column appeared in the <code>key_uniqueword</code> table by using the below command. For an example, lets check for the word "about"</p>
  
  <pre><code>SELECT COUNT(`word`) FROM `key_uniqueword` WHERE `word`="about"
  </code></pre>
  
  <p>Just like this, I need to know how many times "each" unique element in <code>word</code> column appears in the <code>key_uniquword</code> table. I am expecting the output to be like the below table structure. It has 2 columns, <strong>word</strong> and <strong>count</strong></p>
  
  <pre><code>word   |   count
  _ _ _ _ _ _ _ _ _ 
  about  |   99,450
  a      |   1000
  talk   |   7980
  men    |   20,915
  </code></pre>
  
  <p>How can I do this in a MySQL query?
  <strong>Important</strong>
  Please note that <code>p_id</code> not same for every row.</p>