title: mysql fulltext search partial match and quotes
body: <p>After i have normalized my db i am now using fulltext search on myiasm tables.</p>
  
  <p>I have several search scenarios</p>
  
  <ol>
  <li><p>search "hello" IN "hello friend</p></li>
  <li><p>search "hell" IN "hello friend,welcome to hell"</p></li>
  <li><p>search 'fri"ends" in 'come play with fri"ends'</p></li>
  </ol>
  
  <p>I need the best match and currently using</p>
  
  <pre><code>SELECT cu.ID as UID ,MATCH cu.content AGAINST  ('hell')  as relevance
  FROM cht_user cu 
  JOIN cht_agent_script cas ON ( cas.UID = cu.ID AND cas.AID = '315') 
  WHERE MATCH cu.content AGAINST ('hell')  
  ORDER BY relevance DESC 
  </code></pre>
  
  <p>problems are</p>
  
  <ol>
  <li><p>number 3 wont give a result</p></li>
  <li><p>number 2 wont give a result</p></li>
  <li><p>number 1 is the only one that will work</p></li>
  </ol>