title: Searching for keywords in two MySQL columns
body: <p>I have a user table with columns named <em>first_name</em> and <em>last_name</em>.</p>
  
  <pre><code>SELECT * 
      FROM users 
  WHERE first_name LIKE '%keywords%' 
      OR last_name LIKE '%keywords%'
  </code></pre>
  
  <p>Using the above, if I search for "John" or for "Doe" I'll get a hit.  </p>
  
  <p>But if I search for "John Doe" I will get 0 results. How can I search MySQL in a way that will match "first_name last_name" rather than just one or the other?</p>