title: mysql fulltext boolean NOT operator
body: <p>I'm doing a MySQL FULLTEXT search in boolean mode. According to the manual :</p>
  
  <pre><code>Note: The - operator acts only to exclude rows that are otherwise 
  matched by  other search terms. Thus, a boolean-mode search that 
  contains only terms preceded by - returns an empty result. It 
  does not return “all rows except those containing any of the 
  excluded terms.”
  </code></pre>
  
  <p>That's true. </p>
  
  <p>So I use the NOT MATCH operator like this : </p>
  
  <pre><code>SELECT COUNT(*) FROM Table WHERE MATCH (Column) AGAINST 
  ('bar' IN BOOLEAN MODE) AND NOT MATCH (Column) AGAINST 
  ('barbar' IN BOOLEAN MODE);
  </code></pre>
  
  <p>My question is: what is the effect of the + operator in the NOT MATCH field: is </p>
  
  <pre><code>AND NOT MATCH (Column) AGAINST ('foo bar' IN BOOLEAN MODE)
  </code></pre>
  
  <p>the same as :</p>
  
  <pre><code>AND NOT MATCH (Column) AGAINST ('+foo +bar' IN BOOLEAN MODE)
  </code></pre>
  
  <p>Thanks</p>