How to write a MYSQL statement when the time field for intercepting a database in MYSQL is equal to the submitted value?

In MYSQL, when the database truncation time field is equal to the submitted value, how to write MYSQL statement bl_time is a field (for example, 11:33:20)
$ Year is the value submitted by the form (for example, 2014)

... Where YEAR ('ruku. bl_time ') = ". $ Year;

The Year in the bl_time field is equal to the value of $ Year in the form submission.
How can I write the statements after where?

Reply to discussion (solution)

$ SQL = "select * from table where year (bl_time) = '$ year '";

The year is intercepted.
What is the use of month and day?
Month (bl_time) and day (bl_time? I tried it. it seems no way.

It is okay to use month () and day (). Have you tried it.

After half a day, it turns out that the values in the submitted form have not been passed, so no wonder it doesn't work.