Wednesday, February 12, 2014

mysql select values from this month, this year

SELECT * FROM table_name WHERE MONTH(timestamp) = MONTH(CURDATE()) AND YEAR(timestamp) = YEAR(CURDATE())

No comments: