Extracting year from date in mysql query

[twist]

Is there a way to pull the year out of a DATE data field in the query itself?

Something like this,

$query = "SELECT date FROM $database WHERE year = '$year'

The date is stored in the 0000-00-00 format.

[coopster]

$query = "SELECT date FROM $database WHERE YEAR [dev.mysql.com](date) = '$year';

...or if you only want the year returned...

$query = "SELECT YEAR(date) as year  
 FROM $database WHERE YEAR [dev.mysql.com](date) = '$year' 
;

[edited by: coopster at 9:15 pm (utc) on April 29, 2004]

[theriddla1019]

Not that i know of, i do:

Pull It -
Set It -
$date_input = $date;
list($month, $day, $year) = split('[/.-]', $date_input);
Then -
$date = $year

...Dang Coopsters on the ball today :P

[twist]

Thanks coopster, I can't believe how fast replies are sometimes :)