title: mysql complex query in operation
body: <p>I have a problem with the query following:</p>
  
  <pre><code>Update `visitors-processed` as t1 
    SET t1.`landedon`="land" 
  where t1.`Attributes-ip-date-landedon` in  
    (SELECT distinct t2.`Attributes-ip-date-landedon` 
     from `visitors-processed` as t2 
     group by t2.`Attributes-ip-date-landedon`)
  </code></pre>
  
  <p>It is giving me</p>
  
  <blockquote>
    <p>error #1093 - You can't specify target table 't1' for update in FROM clause</p>
  </blockquote>
  
  <p>Any suggestions?</p>