title: CodeIgniter MySQL update mutiple tables at once db->update() db->where()
body: <p>I am using CodeIgniter and want to make a MySQL query that updates multiple tables like this:</p>
  
  <pre><code>UPDATE TABLE1, TABLE2
  SET 
      TABLE1.NAME='Teddy', 
      TABLE2.CLIENT_NOTES = 'Teddy is a good guy' 
  WHERE VISITOR.ID = 1
  </code></pre>
  
  <p>How can I do this using CodeIgniter's <strong>db->update()</strong> and <strong>db->where()</strong>?
  Is this possible?</p>
  
  <p>Thanks for having a look at this.
  Regards.</p>