How to get the records posted in this month in mysql
Related FAQs
- how to find which tables use innodb in mysql
- How to search a tablename in schema
- How to get the students who are in more than one group mysql
- How to find the duplicate rows by comparing two columns in a table mysql
- How to get the length of a string in a column mysql
- How to get the records posted in this month in mysql
- how to find duplicate rows in a table based on specific column
- how to determine constant values in mysql
- how to concatenate all rows of a particular column in a table mysql
- How to connect the mysql from command prompt
Used the DATE_SUB function
Fri, 09/03/2010 - 13:37 — sridhar_piUsed the DATE_SUB function to get the records
select * from feed where updated > DATE_SUB(CURRENT_DATE, INTERVAL 1 MONTH)
To get the last month records
select * from feed where updated between
DATE_SUB(CURRENT_DATE, INTERVAL 2 MONTH) and DATE_SUB(CURRENT_DATE, INTERVAL 1 MONTH)
you can use INTERVAL 1 DAY, INTERVAL 1 WEEK, INTERVAL 2 MONTH ETC.,