title: Why doesn't the FullText search find it?
body: <p>I need a search engine which works on MySql database,
  And I have FULLTEXT index on the columns, but for some reason - Sometimes he finds what I ask him for and sometimes he doesn't - And I really don't understand why.</p>
  
  <p>For instance, I have in my MyIsam <code>songs</code> table a <code>name</code> column which indexed FULLTEXT.</p>
  
  <p>And I have these records:</p>
  
  <p>Sweet child o' mine , Don't Cry</p>
  
  <p>And when I do this query:</p>
  
  <pre><code>$query = $msi-&gt;query("SELECT `name` FROM songs WHERE MATCH(`name`) AGAINST ('Mine') ");
  while($fetch = $query-&gt;fetch_assoc())
  echo $fetch['name']."&lt;br /&gt;";
  </code></pre>
  
  <p>It finds it.</p>
  
  <p>But when I do this:</p>
  
  <pre><code>$query = $msi-&gt;query("SELECT `name` FROM songs WHERE MATCH(`name`) AGAINST ('Dont') "); // or 'don\'t' , 'dont cry' , 'Don\'t Cry' , etc..
  while($fetch = $query-&gt;fetch_assoc())
  echo $fetch['name']."&lt;br /&gt;";
  </code></pre>
  
  <p>It doesn't.</p>
  
  <p>And I really don't understand why..
  Another example is that I have another <code>artist</code> column on the same table which has a record - 'Sia'.
  And even when I do the query to find 'Sia' , it doesn't work!! 
  Can someone explain me why?? (it's not the because of the min length - I use in_boolean_mode)</p>
  
  <p>By the way, I use wampserver, so I thought that it might have something to do with that their MySql is not updated to the last version of it or something like that..</p>
  
  <p>Please Help! I'm desperate.. :(</p>