title: Trying to convert values in SQL to Unix Timestamp
body: <p>I have a Wordpress table that has a bunch of values currently in date format MM/DD/YYYY. This query successfully shows me the Unix Timestamps for them:</p>
  
  <pre><code>SELECT UNIX_TIMESTAMP(STR_TO_DATE(`meta_value`,'%m/%d/%Y'))
  FROM `wp_6222_postmeta`
  WHERE `meta_key`="wpcf-start-date"
  </code></pre>
  
  <p>But I'm struggling to figure out how to write those values back into the field properly. I tried this query and it didn't work:</p>
  
  <pre><code>UPDATE 'wp_6222_postmeta'
  SET 'meta_value' = UNIX_TIMESTAMP(STR_TO_DATE(`meta_value`,'%m/%d/%Y'))
  WHERE 'meta_key' = 'wpcf-start-date'
  </code></pre>