[SOLVED] select statement on date field by specific year

[jboy6t9]

hi.. i am using dreamweaver 8.2, php and mySQL db. my questions is how can i filter a set of records on the date field by only giving the YEAR as the variable. what i want to achieve is a list of listings by year.

 

please could someone help.

 

i tried this but no luck

 

SELECT *

FROM tblProperties

WHERE dateAdded LIKE '%2006'

[trq]

What field type is dateAdded?

[jboy6t9]

its is a date data type

[trq]

SELECT * FROM tblProperties WHERE YEAR(dateAdded) = '2006';

[jboy6t9]

thank you so much for the quick response.. its been bugging me for 2 hrs!

 

IT WORKS!