title: Select single ID in SQL statement with multiple criteria
body: <p>I want to get the post id's wich contain %planet% and %world.</p>
  
  <p>With this statement I would get a single 94 as post_id.</p>
  
  <p>Possible duplicate for the current question is this post: <a href="https://stackoverflow.com/questions/7179260/sql-how-to-select-a-single-id-row-that-meets-multiple-criteria-from-a-singl">SQL: how to select a single id (&quot;row&quot;) that meets multiple criteria from a single column</a></p>
  
  <p>I can't seem to figure out how to use a LIKE statement.</p>
  
  <pre><code>post_id   Meta           Value
  
  96        Hello World    123
  96        Hello World    123
  92        Hello World    123
  93        Hello World    123
  93        Hello World    123
  94        Hello World    123
  94        Hello Planet   1234
  94        Hello World
  95        Hello World
  95        Hello World 
  </code></pre>