我认为您需要:
WHERe (`DATE` between DATE_FORMAT(NOW() ,'%Y-01-01') AND NOW() )
老实说,您可以执行以下操作:
WHERe (`DATE` between DATE_FORMAT(NOW() ,'%Y') AND NOW() )

我认为您需要:
WHERe (`DATE` between DATE_FORMAT(NOW() ,'%Y-01-01') AND NOW() )
老实说,您可以执行以下操作:
WHERe (`DATE` between DATE_FORMAT(NOW() ,'%Y') AND NOW() )