# mySQL dates

**URL:** <https://forum.kirupa.com/t/mysql-dates/162227>\
**Category:** programming\
**Created:** [September 11, 2005, 2:48am UTC](https://forum.kirupa.com/t/mysql-dates/162227 "2005-09-11T02:48:32Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![dinkumrocks](https://avatars.discourse-cdn.com/v4/letter/d/7feea3/32.png) [@dinkumrocks](https://forum.kirupa.com/u/dinkumrocks)\
**Post date:** [September 11, 2005, 2:48am UTC](https://forum.kirupa.com/t/mysql-dates/162227/1 "2005-09-11T02:48:32Z")

</div>

Hey guys. I just switched from Access to MySQL, couse mySQL OWNS. hah.

anyway, I have to list events that haven’t happened yet. In Access, this worked…

SELECT TOP 4 \* FROM events WHERE full\_date \>= #" & Date & "# ORDER BY full\_date;

This is what I have for MySQL…

SELECT \* FROM events WHERE full\_date \>= #" & Date & "# ORDER BY full\_date LIMIT 4;

I know theres probably something simple wrong, but I’m still new to MySql

thanks,  
-Naaman