title: How to replace and update all rows of table where varchar date yyyy-dd-mm to dd-mm-yyyy in mysql
body: <p>I have a <strong>varchar column</strong> with date format as follows <strong>yyyy-mm-dd hh:mm:ss.0</strong> </p>
  
  <p><strong>transactions_table</strong></p>
  
  <pre><code>+-----------------------+
  | transaction_date      |
  +-----------------------+
  | 2020-04-29 19:09:06.0 |
  | 2020-05-13 19:09:06.0 |
  </code></pre>
  
  <hr>
  
  <p>How can I convert above records in <strong>dd-mm-yyyy</strong> and update the same record as follows</p>
  
  <pre><code>+-----------------------+
  | transaction_date      |
  +-----------------------+
  | 29-04-2020           |
  | 13-05-2020           |
  </code></pre>
  
  <p>SQL code:</p>
  
  <pre><code> update transactions_table
      set transaction_date ='manipulated data'
      where transaction_date  like '2020%';
  </code></pre>
  
  <p>How can I convert that string and save the same ?</p>