title: How can I match (mysql) rows by one field and also another field that does not match
body: <p>Say I have a MySQL table with 4 fields:</p>
  
  <pre><code>ID | ONE | TWO | THREE
  </code></pre>
  
  <p>I need to do a query that, in the end result, will show two rows.  I need field 'ONE' to match. Both say 'widget'.</p>
  
  <p>Then, field 'TWO' of one row should match 'MFG' and the other to be anything except 'MFG'.  For example:</p>
  
  <pre><code>ID | ONE | TWO | THREE
  -----------------------
  1  | WID | MFG | sthg
  2  | WID | STR | stes
  </code></pre>
  
  <p>OK, maybe this will help..</p>
  
  <p>This is the statement I have so far.</p>
  
  <pre><code>SELECT * 
  FROM cs_coupons 
  WHERE brand='Zantac'
    AND product='Heartburn Relief 24ct +'
    AND type='MFG'
  
   UNION 
  
  SELECT * 
  FROM cs_coupons 
  WHERE brand='Zantac'
    AND product='Heartburn Relief 24ct +'
    AND type != 'MFG'
  </code></pre>
  
  <p>What I need to do is sort through all the rows checking each brand for these matches.</p>