title: CodeIgniter query: How to move a column value to another column in the same row and save the current time in the original column?
body: <p>In my db table, I have two datetime columns: <code>Last</code> and <code>Current</code>. These column allow me to keep track of when someone last used a valid login to the service I am building up.</p>
  
  <p>Using CodeIgniter's active record, is it possible to update a row so that the <code>Last</code> value receives the <code>Current</code> value AND then the <code>Current</code> value is replace with the current datetime?</p>