title: Mysql Concat two columns while searching with LIKE
body: <p>I am trying to make a MySQL query where I filter the records based on the search text using LIKE keyword.</p>
  
  <p>For example if the user searches for <code>Illusion Softwares</code> where <code>Illusion</code> is First name and <code>Softwares</code> is last name so the query should search for columns FirstName, LastName and concat both and search.</p>
  
  <p>I have tried this so far but it does not work for <code>CONCAT</code></p>
  
  <pre><code> Select Contacts.*, Contacts.ID as CID from Contacts left join
   website_Data  on Contacts.ID = website_Data.ContactID where
   Contacts.`FirstName` LIKE '%Illusion Softwares%' or 
   Contacts.`LastName` LIKE '%Illusion Softwares%' or
   concat(Contacts.FirstName, ' ', Contacts.LastName) 
   LIKE '%Illusion Softwares%'
   or Contacts.Email LIKE '%Illusion Softwares%' 
   order by Contacts.`Created` DESC
  </code></pre>
  
  <p>What am I missing? Please help me.</p>