title: Mysql Full-text search with plus sign
body: <p>I have got a problem.</p>
  
  <p>In my MySql db i have 40000 row in product table. Table has an column called <strong>T9Text</strong>.
  One of my row T9Text area is like this:</p>
  
  <blockquote>
    <p>UNISNLS106B UNI.SNLS 106B SNLS-106B M.OT. 12V 2 DELİK MOTOR CRAFT TİPİ
    UNIPOINT 66-205               66205 F02Z-11390-A         F02Z11390A
    E90Z-11390-A         E90Z11390A F4DZ-11390-A         F4DZ11390A
    F3VY-11390-A         F3VY11390A E90Z-11390-A         E90Z11390A FORD
    ESCORT  MERCURY TRACER  FORD</p>
  </blockquote>
  
  <p>For auto complete process, I run a stored procedure in db. It is like that:</p>
  
  <pre><code>SELECT p.Code, 
    p.Name,
    p.`T9Text`,
    MATCH (p.T9Text) AGAINST ('+UNI* +SNLS* +106B*' IN BOOLEAN MODE) AS SCORE
  FROM product p
  WHERE MATCH (p.T9Text) AGAINST ('+UNI* +SNLS* +106B*' IN BOOLEAN MODE) &gt;0
  GROUP BY p.Name
  ORDER BY SCORE DESC
  </code></pre>
  
  <p>Like this, it works great and return just one row.</p>
  
  <p>But i need to write my where condition like this: </p>
  
  <pre><code>MATCH (p.T9Text) AGAINST ('+*UNI* +*SNLS* +*106B*' IN BOOLEAN MODE) &gt;0
  </code></pre>
  
  <p>With above code it returns 1877 rows. It is like plus sign doesn't work</p>
  
  <pre><code>MATCH (p.T9Text) AGAINST ('+*UNISNLS106B*' IN BOOLEAN MODE) &gt;0
  MATCH (p.T9Text) AGAINST ('+*NISNLS106B*' IN BOOLEAN MODE) &gt;0
  </code></pre>
  
  <p>With first query return 1 row, but second query returns 0 row.</p>
  
  <p>So, there is my question: In mysql fulltext search, can not I use +<em>test</em> expression?
  If not, is there any way to do this? (except LIKE)</p>