title: Group By Column returns two rows of the same value
body: <p>I have a MySQL DB (which is supposed to be in alphabetic order) that contains, English nouns, and their corresponding categories, like food, animals etc. I run the following query so that I can get one from each category;</p>
  
  <pre><code>SELECT english, word, category FROM dict GROUP BY category
  </code></pre>
  
  <p>The result I get is the following;  </p>
  
  <p><a href="https://i.stack.imgur.com/HSE1S.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/HSE1S.png" alt="Query Result"></a> </p>
  
  <p>Its been driving me nuts now, but why are there repetitions of the category Animals, Shapes, Stationaries etc., when I'm grouping by category?</p>
  
  <p>Help me out please. </p>
  
  <p>Additional Info: When I run this query;</p>
  
  <pre><code>SELECT COUNT(*) FROM dict WHERE category = 'Animals'
  </code></pre>
  
  <p>It returns the value 1, but as you can see from the image, it should return more than one. Why are two words which look exactly the same, i.e 'Animals', considered different?</p>