Comparing a given datetime to this time x months ago

[tendrousbeastie]

Hi all,

 

 

This may be a really obvious question, but I had a search and couldn't find an answer to it. Apologies if its answered elsewhere.

 

I need to be able to run an SQL query on my MySQL DB that is essentially like the code below:

 

SELECT fields FROM table WHERE date > now()-12months

 

 

Hopefully my intention is obvious, - I want to return all result from the table where the column date contains a datetime of within the last months (or xx months preferably).

 

Does anyone know the syntax or commands necessary to do this?

[Barand]

SELECT fields FROM table WHERE date > now() - INTERVAL 12 MONTH