title: Update data with latest date in MySQL
body: <p>I have a table <code>tblpushproducts</code>:</p>
  
  <pre><code>identifier  createddate   creator 
  1           15-7-2018     Utrecht (Utr)
  1           1-12-2018     Utrecht (Utr)
  1           14-2-2019     Utrecht (Utr)            
  2           12-12-2018    Utrecht (Utr)
  2           12-02-2019    Utrecht (Utr)
  </code></pre>
  
  <p>I want to update the value in column <code>creator</code> from <code>Utrecht (Utr)</code> to <code>Utrecht</code>.
  But, as you can see, there are multiple rows for same identifier.
  I want to update only the rows with latest date.</p>
  
  <p>So, for example, in this case only these rows should be updated: </p>
  
  <pre><code>1           14-2-2019     Utrecht (Utr)
  2           12-02-2019    Utrecht (Utr)
  </code></pre>