filtering data with today's date

[shankari07]

hi guys,
i've a sql like this
select * from <table name> where <fieldname> > today's date;
in the place of today's date which function i can use.

[r035198x]

hi guys,
i've a sql like this
select * from <table name> where <fieldname> > today's date;
in the place of today's date which function i can use.

Take your pick.

[Samyyy]

hi guys,
i've a sql like this
select * from <table name> where <fieldname> > today's date;
in the place of today's date which function i can use.

hello shankar...

We have many date functions in mysql, but the most appropriate will be CURDATE()
this will work for you..

select * from <table name> where <fieldname> > CURDATE();

replace table name and field name with the exact data.