Using current year to match against where clause

[Xtremer360]

I'm not quite how I should be doing this but I"m trying to have it select where the events.bookingdate is from any that were taken place in the current year. I"m not sure how to adjust my WHERE clause.

 

WHERE

        events.bookingDate ="?"

[requinix]

WHERE events.bookingDate >= "YYYY-01-01" AND events.bookingDate 

date("Y") will give you the current year.

[Xtremer360]

How would I put the date("Y") into that

[Drummin]

Add above query

$yearstart=date("Y-1-1");
$yearend=date("Y-12-31");

And this inside

WHERE events.bookingDate >= "$yearstart" AND events.bookingDate <= "$yearend"

[mikosiko]

other option:

 

WHERE DATE_FORMAT(events.bookingDate,'%Y') = DATE_FORMAT(curdate(),'%Y');

[Xtremer360]

Thank you to both of you.