title: Wordpress SQL request with data from array in WHERE clause
body: <p>I need your help. I'm working on a small plugin for some email verifications in wordpress and now I'm struggeling.</p>
  
  <p>I want to get an array of ID's and I get them by following code:</p>
  
  <pre><code>function myFuntion () {
          global $wpdb;
          $supporterIDArray = $wpdb-&gt;get_results("SELECT id FROM myTable WHERE value = 'true' AND field_id = 1");
      }
  </code></pre>
  
  <p>Now I get an array of an unknown number of ID's like [7, 9, 34, 53, ...]</p>
  
  <p>After that I want to count how many other rows have this ID. But I don't know how to do that, the could shold be like this...</p>
  
  <pre><code>global $wpdb;
  $countSupporters = $wpdb-&gt;get_results("SELECT COUNT(*) AS allSupporter FROM myTable WHERE value = 'true' AND field_id = '2' AND `id` = **THESE IDS FORM THE ARRAY**");
  echo $countSupporters -&gt; allSupporter; /*Number of all ROWs which have an ID wich was in the array
  </code></pre>
  
  <p>I hope I explained it good enough and would be so grateful if you could help me. Thanks!</p>