title: Change Value in MySQL Table Based on Date-Range
body: <p>I'm trying to change the status of a post from 'Inherit' to 'Published', but only for posts with dates between 08/01/2012 &amp; 10/08/2012. Would this be the proper query to run to achieve this?</p>
  
  <pre><code>UPDATE wp_posts set post_status = replace(post_content, 'inherit', 'published') WHERE post_date BETWEEN '2012/08/01 00:00:00.000' AND '2012/10/08 23:59:00.000'
  </code></pre>