title: How to update data in Mysql using "not equal" condition
body: <p>I have a database that has a table named property_list, and a column named agent. for now there is a lot of name inside it.</p>
  <pre><code>$agent = array(&quot;Tony&quot;,&quot;Nava&quot;,&quot;Ceri&quot;,&quot;Van&quot;,&quot;Turker&quot;);
  </code></pre>
  <p>Many things happen lately, and most of them are out and we need to change their name to Property Agent in table &quot;property_list&quot;, except agent named Ceri and Van.</p>
  <p>i have try this Query but it apperantly changes all the agent list at the table</p>
  <pre><code>UPDATE property_list SET agent = &quot;Property Agent&quot; WHERE agent != &quot;Ceri&quot; OR agent != &quot;Van&quot;;
  </code></pre>
  <p>am i do it wrong?, currently using mysql and php to run the code.</p>