title: MySQL - CONCAT two fields and use them in WHERE clause
body: <p>As the title suggests, I was wondering how to <code>concat</code> two fields in a <code>where clause</code> in <code>mysql</code>. This is an example of what I'm trying to achieve :</p>
  
  <pre><code>SELECT CONCAT_WS(' ', first_name, last_name) AS name FROM `users`
  WHERE name LIKE "%John Doe%"
  </code></pre>
  
  <p>The point is that <code>first_name</code> and <code>last_name</code> are separate fields, and I want to enable my <code>PHP</code> application to search for a full person's name.</p>
  
  <p>Any tips?</p>
  
  <p>Cheers!</p>