title: get nearest next one date records in mysql
body: <p>i am having an event table.and i show events for today using.<br><code>SELECT *
  FROM `special_banner_tbl`
  WHERE `SPLBANNER_pubsdate` = current_date
  </code><br><br> if there is no events for today, it have to display the future day record which is more near to current date. <br>if the table like..<br>------------------<br>future_date<br>------------------<br>30-11-2013<br>30-11-2013<br>02-12-2013<br>03-12-2013<br>03-12-2013<br>----------------------<br>it will display the next nearest date <strong>30-11-2013</strong> records.. like.<br><br> <code>SELECT * FROM `special_banner_tbl` WHERE `SPLBANNER_pubsdate` = nest_nearest_date_records</code></p>
  
  <p>only one nearest future date records without any <strong>limit</strong>. like<br>---------------     --------------<br>events                 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;future-dates<br>---------------   ----------------<br>30th-events &nbsp;&nbsp;30-11-2013<br>
  30th-events &nbsp;&nbsp;30-11-2013<br>------------------------------</p>