MySQL Query: Query All Entries Older Than 1 Year

Question

I am putting together a membership database for a nonprofit charity in LibreOffice, but have no experience in mysql queries so I would appreciate the help.

I am trying to create a query that displays all records where the membership signup date field (PaymentDate) is older than 1 year of the current date AND a boolean value of another field (AwaitingRenewal) is NO. The date is in 05/03/85 format. Thanks for any help you can give me!

Answer 1

You can do something like:

select * from `members` 
  where `paymentDate` < DATE_SUB(CURDATE(), INTERVAL 1 YEAR)
  and `AwaitingRenewal` = 'NO'