title: How can I convert String to Date in phpMyAdmin?
body: <p>I'm a web designer, new to php/sql/phpMyAdmin, but learning fast.</p>
  
  <p>I have imported data with the column "Entry_Date" in the following incorrect format:  (mm/dd/yyyy) Which I now need converted to the correct DATE format/type.</p>
  
  <p>I have set up 2 columns<br />
  1) Entry_Date - char(10)<br />
  2) New_Date - date</p>
  
  <p>In phpMySql, int the myTable's "SQL" tab, I ran;</p>
  
  <pre><code>UPDATE myTable(New_Date)
  SELECT STR_TO_DATE(Entry_Date,'%m/%d/%Y') as date FROM `myTable`;
  </code></pre>
  
  <p>I confirmed the SELECT STR_TO_DATE line is successfully converting the string to DATE,  but I am not able to get those values to UPDATE the New_Date column (which is already populatred with "0000-00-00".  What am I missing?</p>