title: mysql FULLTEXT search multiple words
body: <p>I've never really heard a straight answer on this one, I just need to FULLTEXT search a couple columns with multiple words "Firstname Lastname"</p>
  
  <pre><code>$sql = mysql_query("SELECT * FROM 
                      patient_db 
                      WHERE MATCH ( Name, id_number )
                      AGAINST ('% $term %' IN BOOLEAN MODE);");
  </code></pre>
  
  <p>But it fails to run the query if I enter more than one word here.</p>