title: check all the list of id value available in table mysql query
body: <p>table</p>
  
  <pre><code>id | catid | productid | 
  
  1     3        100
  
  2     244      110
  
  3     400       300   
  </code></pre>
  
  <p>Hi, here is my query , </p>
  
  <pre><code>select catid from table where catid NOT IN ('3','244','5')
  </code></pre>
  
  <p>i have a table looking like that above ,</p>
  
  <p>1- what i need ,i have to check some list of catid values ,
  if all the list catid is available an the table will return "yes" or some "rows".</p>
  
  <p>2- Otherwise will return "no" all the list catid not available ?</p>
  
  <h1>I had tried but its useless ?</h1>
  
  <p>This is not correct one for my expecting result ?</p>
  
  <p>SELECT catid , IF(catid IS NOT NULL , "Yes" , "No") FROM table where catid IN ('3','244','5');</p>
  
  <p>what i need , the list of cat ids are "('3','244','5')" should be available an the table if once value missing an the table will return "No" </p>
  
  <p>thanks for your help ?</p>