title: How to delete a certain row from mysql table with same column values?
body: <p>I have a problem with my queries in MySQL. My table has 4 columns and it looks something like this:</p>
  
  <pre><code>id_users    id_product    quantity    date
   1              2              1       2013
   1              2              1       2013
   2              2              1       2013
   1              3              1       2013
  </code></pre>
  
  <p><code>id_users</code> and <code>id_product</code> are foreign keys from different tables.  </p>
  
  <p>What I want is to delete just one row:  </p>
  
  <pre><code>1     2     1    2013
  </code></pre>
  
  <p>Which appears twice, so I just want to delete it.  </p>
  
  <p>I've tried this query:  </p>
  
  <pre><code>delete from orders where id_users = 1 and id_product = 2
  </code></pre>
  
  <p>But it will delete both of them (since they are duplicated). Any hints on solving this problem?</p>