title: What's wrong with this UPDATE statement?
body: <p>I need a SQL query to run</p>
  
  <pre><code>UPDATE function
  SET active = 0
  WHERE unitRef IN
      (SELECT unitRef 
         FROM project_unit 
        WHERE projectRef = 1);
  </code></pre>
  
  <p>When I run this query, phpmyadmin says that 0 rows are affected. 
  However when I run following code standalone:</p>
  
  <pre><code>SELECT unitRef 
    FROM project_unit 
   WHERE projectRef = 1
  </code></pre>
  
  <p>it returns me more than 1 row.</p>
  
  <p>Am I doing something wrong?</p>