how to check expiration date in mysql

[pbcomput]

hi.

i want to check expire date with mysql query between start date and enddate.

if the end date is bigger then today's date then its good else it didnt display records.

can any one please help me out.

Thanks in advance. :)

[pbcomput]

if any one know plase help me out.

Thanks.

[zaxonus]

How about using this condition ?
(EnDate<now())

This is what use myself and it works fine.

[Taywin]

Don't think this question is for javascript??? Or you are talking about attempting to do the comparison of dates obtained by mysql on a HTML page?

[pritaeas]

http://www.daniweb.com/forums/thread290114.html

[jhansianamaneni]

select * from table name where account_expiry < now();
try this it is working fine.