title: MySQL - Delete with multiple conditions
body: <p>I have a database with properties and I need to delete all the properties except for those "owned" by either one of 3 "Inscription Agents". Each property can have up to 2 "owners": <code>agent_inscripteur_1</code> and <code>agent_inscripteur_2</code> on the database.
  This is my code:</p>
  
  <pre><code>DELETE FROM inscriptions 
  WHERE (agent_inscripteur_1 != 100520 OR agent_inscripteur_2 != 100520) 
        AND (agent_inscripteur_1 != 97927 OR agent_inscripteur_2 != 97927) 
        AND (agent_inscripteur_1 != 99237 OR agent_inscripteur_2 != 99237)
  </code></pre>
  
  <p>I think what is happening in my case is that the first part of the code before the <code>AND</code> is executed before the rest, so all properties except for those listed by the first agent are being deleted (by the time it gets to the second and third agent, the properties are all gone).</p>
  
  <p>Can someone please point me in the right direction?</p>
  
  <p>Thanks!</p>