title: PHP & SQL: WHERE MATCH to look for two or more columns
body: <p>I am having some difficulties looking for exact match in two or more columns using WHERE MATCH. Below script which I tried:</p>
  
  <pre><code>SELECT * FROM people WHERE MATCH (_fristname) AGAINST ('$search') LIMIT 0, 2;
  </code></pre>
  
  <p>The code above is working perfectly,</p>
  
  <pre><code>SELECT * FROM people WHERE MATCH (_lastname) AGAINST ('$search') LIMIT 0, 2;
  </code></pre>
  
  <p>The code above is working too,</p>
  
  <pre><code>SELECT * FROM people WHERE MATCH (_firstname, _lastname) AGAINST ('$search') LIMIT 0, 2;
  </code></pre>
  
  <p>The code above is not working. I want to search for exact match in both columns</p>
  
  <p>The code below is what I used to output in PHP:</p>
  
  <pre><code>$searched = mysqli_query($connect, $sql);
  while($info = mysqli_fetch_array($searched)) {
     echo $info['_jobdescription'];
  }
  </code></pre>