title: MySQL: Something wrong with Fulltext search - Returning NO results
body: <p>I have a table <code>places(name  vachar(50), address text, description text) engine = MYISAM</code> and few records.</p>
  
  <p>I have been trying to do some example in <a href="http://dev.mysql.com/doc/refman/5.0/en/fulltext-search.html" rel="noreferrer">here</a>!, and searching for the 'full-text problem'  but i have not clear about fulltext search. </p>
  
  <p>First, i add a fulltext index by: </p>
  
  <pre><code>ALTER TABLE places ADD FULLTEXT(name, address, description);
  </code></pre>
  
  <p>and try mySQL: </p>
  
  <pre><code>SELECT * FROM places WHERE MATCH(name,address,description) AGAINST('my search key');
  </code></pre>
  
  <p>i have try some 'my search key' that content is in many field, but there are some case i got:</p>
  
  <ul>
  <li><p>now row selected .</p></li>
  <li><p>if  i trying <code>add option "IN BOOLEAN MODE" in AGAINST()</code>, result obtained with score =1 , its is meaningless when i  sort it .</p></li>
  <li><p>it just show the result when the "search key" has content in field (name).</p></li>
  </ul>
  
  <p>i tried a lot way but i don't remember all cases,</p>
  
  <p>Any answer could help!</p>
  
  <p>Thanks in advance!</p>