PHP - mysqli_query - WHERE和日期

I have a PHP query that I only want to select if the date is 2014 in the table:

$result=mysqli_query($linkID, "SELECT * FROM table WHERE date(Y) = '2014'";

I'm trying to call "date(Y)" with the correct expression as that is obviously incorrect.

Use this:

$result=mysqli_query($linkID, "SELECT * FROM table WHERE YEAR(datetime_field) = 2014");

the query should be

SELECT * FROM table WHERE YEAR(the_date_field) = 2014

the_date_field is the field containing the date of course