title: MySql: Query select two dates having one month difference between
body: <p>I have one column date in MySQL table with dates like-</p>
  
  <pre><code>01/01/2014
  02/01/2014
  05/01/2014
  06/01/2014
  25/04/2014
  26/04/2014
  27/04/2014
  28/04/2014
  29/09/2014
  30/09/2014
  01/10/2014
  </code></pre>
  
  <p>i need to select starting and ending dates having minimum 30 days difference between those dates like from above dates i would get</p>
  
  <pre><code>Starting Date   -      Ending Date
  
  01/01/2014     -        06/01/2014
  
  25/04/2014      -       28/04/2014
  
  29/09/2014      -       01/10/2014
  </code></pre>
  
  <p>How can I do this in a MySQL select query?</p>
  
  <p>Thanks</p>