title: Combining two fields in SELECT statement
body: <p>In my table I have a field "firstname" and a field "lastname". I would like to select all records where firstname + space + lastname is a certain value.</p>
  
  <p>I've tried this:</p>
  
  <pre><code>$sql = "SELECT * FROM sam_users WHERE (user_firstname + ' ' + user_lastname LIKE ?)";
  </code></pre>
  
  <p>But this isn't working. With Google I've found something about using ||, but I don't really understand how I should use that operator. Note that I don't want to use an or-operator (what || is in many languages), but something to concatenate 2 fields (with a space between them) and using a LIKE on that.</p>
  
  <p>Thanks!</p>