title: MySQL fails to match string
body: <p>I have the following table:</p>
  
  <pre><code>CREATE TABLE IF NOT EXISTS `words` (
  `Id` int(11) NOT NULL,
  `word` varchar(100) NOT NULL,
  FULLTEXT KEY `word` (`word`)
  ) ENGINE=MyISAM DEFAULT CHARSET=utf8
  </code></pre>
  
  <p>The following query returns all rows that contain the word 'person':</p>
  
  <pre><code>SELECT *  
  FROM `words` 
  WHERE `word` LIKE '%person%'
  </code></pre>
  
  <p>The following query returns nothing even though there is a row that only contains the word 'person':</p>
  
  <pre><code>SELECT *  
  FROM `words` 
  WHERE `word` = 'person'
  </code></pre>
  
  <p>Any clues? I'm confused.</p>