PHP Developers Php tutorials References Faq MySql Developers MySql tutorials References Faq Linux Developers Linux tutorials References Faq Web Designing Webdesign tutorials
Here is an example that uses date functions. The following query selects all records with a date_col value from within the last 30 days: mysql> SELECT something FROM tbl_name -> WHERE DATE_SUB(CURDATE(),INTERVAL 30 DAY) <= date_col;
Here is an example that uses date functions. The
following query selects all records with a date_col
date_col
value from within the last 30 days:
mysql> SELECT something FROM tbl_name -> WHERE DATE_SUB(CURDATE(),INTERVAL 30 DAY)
SELECT something FROM tbl_name
something
tbl_name
WHERE DATE_SUB(CURDATE(),INTERVAL 30 DAY)
<= date_col;
