title: Delete only the row where both conditions is met
body: <p>For example:</p>
  
  <p>I have a table with shoppinglists that contains user_ids and list_names like this:</p>
  
  <ul>
  <li>user_id 1, list_name 1 </li>
  <li>user_id 1, list_name 2 </li>
  <li>user_id 2, list_name 1</li>
  </ul>
  
  <p>Is there a way for me to delete only the row where user_id = 1 and list_id = 1, so that user_id 2, list_name 1 and user_id 1, list_name 2 stays? </p>
  
  <p>I have used this code:</p>
  
  <pre><code>mysql_query("DELETE 
                 FROM user_in_shoppinglists 
                WHERE (user_id = '$user_id' AND list_id = '$list_id')
              ")
  </code></pre>
  
  <p>But it removes the rows with both list_name 1 and list_name 2 for user_id 1.</p>