get date less than 15 days from now

[hassank1]

Hi

in my db there's a field called ExpiryDate which is a date field

 

I want to execute a query that will get me all the users in which their account will expire in less than 15 days..

 

in other words all the users whose accounts will expire in less than 15 days

 

thx

 

I am using mysql 5.0.51 ..

 

[kickstart]

Hi

 

Something like this:-

 

SELECT *

FROM SomeTableWithDate

WHERE ExpiryDate < ( now( ) + INTERVAL 15 DAY )

 

All the best

 

Keith