title: Is it possible for a mysql query to return true/false instead of values?
body: <p>I have a table:</p>
  
  <pre><code>custID    orderID    orderComponent
  =====================================
  1          123        pizza
  1          123        wings
  1          234        breadsticks
  1          239        salad
  2          456        pizza
  2          890        salad
  </code></pre>
  
  <p>I have a list of values - pizza, wings, breadsticks, and salad. I need a way to just get a true/false value if a customer has at least one record containing each of these. Is that possible with a mysql query, or do I just have to do a <code>select distinct(orderComponent)</code> for each user and use php to check the results?</p>