title: How to do a LIKE considering two columns?
body: <p>I have a customer table with two columns <code>first_name</code> and <code>last_name</code>.</p>
  
  <p>How can I use LIKE in a query being able to get data from both columns at same tame?</p>
  
  <p>For instance:</p>
  
  <pre><code>SELECT CONCAT(first_name, ' ', last_name) as 'full_name' 
  FROM customer WHERE full_name LIKE 'John D%'
  </code></pre>
  
  <p>I've tried this and it tells me <code>full_name</code> column doesn't exist.</p>