MYSQL 查询本月

SELECT * FROM log_data WHERE DATE_FORMAT(create_time,'%Y%m') = DATE_FORMAT(CURDATE(),'%Y%m');