title: Combine two columns in SQL for WHERE clause
body: <p>In my SQL, I am using the <code>WHERE</code> and <code>LIKE</code> clauses to perform a search. However, I need to perform the search on a combined value of two columns - <code>first_name</code> and <code>last_name</code>:</p>
  
  <p><code>WHERE customers.first_name + customers.last_name LIKE '%John Smith%'</code></p>
  
  <p>This doesn't work, but I wondered how I could do something along these lines?</p>
  
  <p>I have tried to do seperate the search by the two columns, like so:</p>
  
  <p><code>WHERE customers.first_name LIKE '%John Smith%' OR customers.last_name LIKE '%John Smith%'</code></p>
  
  <p>But obviously that will not work, because the search query is the combined value of these two columns.</p>