title: Change data format in existing field in mysql
body: <p>In my db I have column in which there is about 1k~ records. All records have name field in which is overwrite also data. For eg. "name 7/24/2006". I need to change format mm/dd/yyyy to dd/mm/yyyy. Correctly it should be 24/07/2006. I tried to add this function: <a href="https://techras.wordpress.com/2011/06/02/regex-replace-for-mysql/" rel="nofollow">https://techras.wordpress.com/2011/06/02/regex-replace-for-mysql/</a> and run </p>
  
  <pre><code>SELECT regex_replace('(\d+)\/(\d+)\/(\d+)$','$2/$1/$3',column_name`) `column_name` 
  FROM` `table_name` 
  </code></pre>
  
  <p>but it doesn't work. Any ideas how to fix it?</p>