title: Mysql Update Query IN phrase
body: <p>Attention sql gurus,</p>
  
  <p>How can I perform such a query?</p>
  
  <pre><code>UPDATE `qwiki`
  SET haspix=1
  where eword in (select distinct fmtag
                  from qtagid)
  </code></pre>
  
  <p>It should basically set the 'haspix' flag to true for ewords found in another table.</p>
  
  <p>Thanks </p>