title: mysql match against multiple words
body: <p>Below is an example sql I am stuck with, it will not return a product named "iphone 4s", It returns 10 other result. Any help would be great thanks</p>
  
  <h2>1st sql example</h2>
  
  <pre><code>SELECT * FROM products 
            WHERE match(desc) against('+iphone +4s' IN BOOLEAN MODE) LIMIT 10";
  </code></pre>
  
  <p>result: contains the words 'iphone' and '4s' </p>
  
  <h2>2nd sql example</h2>
  
  <pre><code>SELECT * FROM products 
             WHERE match(desc) against('+iphone 4s' IN BOOLEAN MODE) LIMIT 10";
  </code></pre>
  
  <p>result: contains the words 'iphone', but rank rows higher if they also contain '4s'</p>
  
  <h2>3rd sql example</h2>
  
  <pre><code>SELECT * FROM products 
             WHERE match(desc) against('iphone 4s' IN BOOLEAN MODE) LIMIT 10";
  </code></pre>
  
  <p>result: contains the words 'iphone' or '4s'</p>
  
  <p>What I want to search is 'iphone 4s', but it comes with other result, like 'iphone is good, but 4s...', 'new iphone 5 has published...',...</p>
  
  <p>Can anyone help me to solve it? thanks.</p>