MYSQL使用LIKE函数查询日期

Question

I have the following statement in the where statement of a mysql query:

WHERE scrap_date LIKE '%-01-%'

I want to grab all the data with the scrap_date being in January. The error I recieve is:

"Incorrect datetime value: '%-01-%' for column 'scrap_date' at row 1"

The datatype for scrap_date is DATETIME. Not sure what syntax to use to get data with the a date in January, any suggestions?

Answer 1

You are assuming the date is represented internally as a string. It is not.

Since its a DateTime, use the MONTH function to extract the month and compare it to the desired value

WHERE MONTH(scrap_date) = 1