title: How to update only month in date column?
body: <p>I have one table with 30 entries and date column is like following</p>
  
  <pre><code>2014-11-01
  2014-11-02
  2014-11-03
  .
  .
  .
  2014-11-30
  </code></pre>
  
  <p>Now i want to write MySQL query to update month from 11 to 10 or you can say from month November to October.</p>
  
  <p>I want to change only month in all these dates from 11 to 10.</p>