title: How do I select multiple values in the same column?
body: <p>I am trying to select multiple values in a single column. Basically I want the query to select all those under column <code>family</code> with values <code>Software_1Y</code>,<code>XI_1Y</code> and <code>P1_1Y</code></p>
  
  <p>I am running this query :</p>
  
  <pre><code>SELECT `salesorder`
      ,`masterproduct`
      ,`family`
      ,`birthstamp`
      ,`duedate`
      ,COUNT(*) AS `total`
  FROM `report`
  WHERE `birthstamp` BETWEEN '$startDT'
          AND '$endDT'
      AND `family` = 'Software_1Y'
      AND `family = 'XI_1Y'
      AND `family` = 'PI_1Y'
  GROUP BY `salesorder`
      ,`masterproduct`
      ,`family`
      ,`duedate`;
  </code></pre>
  
  <p>My query returns no rows but is I search each family one by one, I have values.</p>
  
  <p>What is wrong with my query?</p>
  
  <p>Also, my purpose is to get all the rows whose <code>family</code> values are <code>Software_1Y</code>, <code>XI_1Y</code> and <code>PI_1Y</code>. </p>