title: Compare value with concatenated fields in where clause
body: <p>Say I want to search for a user, 'Richard Best'. Is it possible to compare the full name is concatenated first name and last name? I do not have  a full name field.</p>
  
  <pre><code>select * from users where last_name + ' ' + first_name like '%richa%'
  </code></pre>
  
  <p>I am using Mysql</p>