title: How to search with firstname and last name in - Mysql
body: <p>Consider I am having tow fields in my table</p>
  
  <pre><code>field_profile_first_name_value      field_profile_last_name_value
  
  Victor                              Brecher
  Abhi                                Jass             
  
  select field_profile_first_name_value, field_profile_last_name_value 
  from content_type_profile where field_profile_first_name_value LIKE '%Victor Bre%' OR 
  field_profile_last_name_value LIKE '%Victor Bre%'
  </code></pre>
  
  <p>I am having a auto complete text box. </p>
  
  <p><strong>When i enter the keyword as victor it will fetch the result. But if i give the first name and last name in the same time it will not produce the result.</strong></p>
  
  <p><strong>That is if i give the keyword as Victor Brecher it will not produce the result.</strong></p>
  
  <p>How can i make to get the result if i enter first name and last name ?</p>
  
  <p>How can i make it ?</p>