title: MySQL, FULLTEXT in phpmyadmin
body: <p>I've created a <code>FULLTEXT</code> index for the TEXT column <code>myColumn</code> my <code>MySQL</code> database in phpmyadmin.</p>
  
  <ol>
  <li><p>The index for this column is reporting a cardinality of <code>50581</code>, exactly one third the number of rows in my table (i.e. 151743). Why is that? And does it matter? (I have also three TEXT columns, if that matters.)</p></li>
  <li><p>I ask because my <code>MATCH</code> searches seem to be missing hits. For example, if I do <code>SELECT * FROM myTable WHERE MATCH(myColumn) AGAINST ('dude') ORDER BY id LIMIT 30</code> returns hits whereas <code>SELECT * FROM myTable WHERE MATCH(myColumn) AGAINST ('want') ORDER BY id LIMIT 30</code> returns none (when say <code>...LIKE '%want%'...</code> returns lots). Why is that?</p></li>
  </ol>