Getting most recent date from table....

[ratpH1nk]

I am trying to construct a query that goes something like this:

select * from MyTable
where MyDate is '$date_var'

In this case I need $date_var to bring back what ever is the most recent entry in that table?

Any suggestions?

---

edit:

As a side note, is this not a legal option? I mean, MySQL doesn't give me an error about syntax:
alter table 'MyTable' change 'date' 'date' DATE default CURDATE() NOT NULL

[Sxooter]

Sure, you just do this:

select * from table order by date desc limit 1;

[ratpH1nk]

Thanks SXooter!!