mySQL dates

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