title: MySQL Full Text Search not working properly. Why?
body: <p><strong>OBS:</strong> I'm new to Full Text Searches and MyIsam engine, so assue I know basically nothing about it.</p>
  
  <p>Here's my DDL:</p>
  
  <pre><code>CREATE TABLE NotebookIndex (
      indexAutomatico TEXT,
      indexHumano TEXT,
      notebook BIGINT UNSIGNED
  ) CHARACTER SET utf8 COLLATE utf8_general_ci ENGINE=MYISAM;
  ALTER TABLE NotebookIndex ADD FULLTEXT(indexAutomatico, indexHumano);
  </code></pre>
  
  <p>And here's my database right now:</p>
  
  <p><img src="https://i.stack.imgur.com/1zfRH.png" alt="enter image description here"></p>
  
  <p>When I query:</p>
  
  <pre><code>SELECT notebook FROM NotebookIndex WHERE MATCH(indexHumano, indexAutomatico) AGAINST ('intel')
  </code></pre>
  
  <p>I'm getting this:</p>
  
  <p><img src="https://i.stack.imgur.com/gL59P.png" alt="enter image description here"></p>
  
  <p>If you look closely to the print screen, you will be able to see that <code>'intel'</code> does exists in some of the lines.</p>
  
  <p>Although, if I change <code>'intel'</code> to <code>'sony'</code> i get some results. I tried some other (existent) words and it doesn't work either. Why is this happening?</p>