title: How to select two columns as one?
body: <p>I'm trying to search two fields as one from a MySQL database using PHP.</p>
  
  <p><strong>e.g.</strong></p>
  
  <pre><code>mysql_query("
    SELECT (first_name,last_name) As name
    FROM people
    WHERE (name LIKE '%" . $term . "%')
  ");
  </code></pre>
  
  <p>I thought that this was the code to use, but to no avail. It has been a while since I've done this and I can't remember exactly how to achieve the desired result.</p>