 <p>Does this do it:</p> <pre><code>UPDATE tbl SET defaultHours = 5 WHERE ts &gt;= CURRENT_DATE() - INTERVAL 1 MONTH AND ts &lt; CURRENT_DATE() - INTERVAL 1 MONTH + INTERVAL 1 DAY </code></pre> <p>?</p>