[RESOLVED] Query where the date field contains '2006'

[joshmpratt]

I'm going to be pulling records from a MySQL database and I want to pull only the records that contain '2006' in the date field.

The date field is formatted like this: 2006-09-18

So how would I add to this to only pull out 2006 records?:

$db->query("SELECT * FROM needs WHERE ")

Thanks!

[Installer]

$db->query("SELECT * FROM needs WHERE YEAR(date_field) = '2006'");

[joshmpratt]

Thank you! Works great.