title: Update multiple Rows in Codeigniter
body: <p>I have been looking around but I have not found an answer yet. Kindly help if you know the answer.</p>
  
  <p>How do you update multiple rows in CI?</p>
  
  <p>In my MySQL:</p>
  
  <p>I have column names:</p>
  
  <pre><code>ID, Settings Name, Settings Value ( Settings Name is Unique )
  </code></pre>
  
  <p>I have the ff Data:</p>
  
  <pre><code>ID = 1, Settings Name = "Hello" , Settings Value = "True"
  ID = 2, Settings Name = "World", Settings Value = "Good"
  </code></pre>
  
  <p>and more ...</p>
  
  <p>I also have a form that gets the <code>Settings Value</code> but I am not sure how to update it on the DB. How to update the <code>True</code> for the <code>Hello</code> being the <code>Settings Name</code> and update the <code>Good</code> for the <code>World</code>.</p>
  
  <p>I heard about <code>insert_batch()</code> but is there an <code>update_batch()</code>?</p>