[SOLVED] Help with SELECT statement

[Ne0_Dev]

Hi All,

 

I am trying to filter my records to show articles that are only 3 years old.  here is my query:

 

"SELECT * FROM tbl_newsarticles WHERE created >= YEAR() -3 ORDER BY created DESC";

 

The date format is stored in the database as datetime, so I am presuming I need to format it to show only the Year when comparing. I am sure that this is a simple fix, but can't seem to work it out  :-\

 

Any help greatly appreciated!

 

 

[zenag]

"SELECT * FROM tbl_newsarticles WHERE year(created) -3  as year ORDER BY year DESC";

[Ne0_Dev]

Hi Zenag,

 

When runing the query I am getting the following error:

 

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'as year ORDER BY year DESC' at line 1

 

Any suggestions?

 

Cheers

[zenag]

"SELECT * FROM tbl_newsarticles WHERE year(created)=year(curdate())-3 ORDER BY created DESC";

[Ne0_Dev]

Zenag

 

Thanks for the updated query, I have implemented it and with on adjustment I now have it working as intended.  the only thing I added was the 'greater than' operator.

 

"SELECT * FROM tbl_newsarticles WHERE year(created)>=year(curdate())-3 ORDER BY created DESC";

 

Thanks for the help.

 

Moat appreciated