title: Need Search two values in one field Mysql
body: <p>I need search for two values in the same field.</p>
  
  <pre><code>╔════╦════════════╦══════════════╗
  ║ ID ║ Meta_key   ║ Meta_value   ║
  ╠════╬════════════╬══════════════╣
  ║  1 ║ first_name ║    pritesh   ║
  ║  2 ║ last_name  ║    mahajan   ║
  ║  3 ║ first_name ║    ritesh    ║
  ║  4 ║ last_name  ║    jain      ║
  ║  5 ║ first_name ║    john      ║
  ║  6 ║ last_name  ║    a         ║
  ║  7 ║ first_name ║    Mambo     ║
  ║  8 ║ last_name  ║    Nombo     ║
  ╚════╩════════════╩══════════════╝  
  </code></pre>
  
  <p>This is my table and I want to search all the first names and last names. Below is my query but this does not return what I want.</p>
  
  <pre><code>SELECT * 
  FROM `wp_usermeta` 
  WHERE `meta_key` = 'last_name' 
    AND `meta_value` LIKE  '%mahajan%' 
    AND `meta_key` = 'first_name' 
    AND `meta_value` LIKE  '%a%'; 
  </code></pre>