title: MySQL select last day of month exsist in table
body: <p>I'm trying to get data from mysql where the date are at the end of month.<br/>
  Example:<br/></p>
  
  <pre><code>id date       name
  ===================
  1  2002-02-23 aaaa
  2  2002-02-23 bbbb
  3  2002-03-01 cccc
  </code></pre>
  
  <p>As you can see the last input on february are only at date 23 because of various reason.<br/>
  Is there a way so that i can only select the last date of month <strong>existed</strong> in database?</p>