compare dates

[pdsmet]

Hi,
is it possible to compare two dates,
one set in a record in a mysql database
and the other one is todays date (getdate)
If getdate >= date in database, then the rest of the fields of that record should be displayed, if not, nothing of that record should be showed.
Is this possible and how ?
Thanks a lot for your help
Peter

[Lars_Berg]

You can use the function current_date

select <columnsOfInterest> 
from <yourTable>
where <yourDateColumn> <= current_date

[pdsmet]

thanks
Peter