How to select last 6 months from news table using MySQL

 .... where yourdate_column > DATE_SUB(now(), INTERVAL 6 MONTH)

相关推荐

Getting the last row of a table using jQuery?

4 年前
Select first and last element with particular class using jQuery

4 年前
Syntax error due to using a reserved word as a table or column name in MySQL

1 年前
MySql Error: Can't update table in stored function/trigger because it is already used by statement which invoked this stored function/trigger

1 年前
SQL Server: should I use information_schema tables over sys tables?

1 年前
How do I use jQuery to select all children except a select element

1 年前
MySQL update table based on another tables value

1 年前
mysql-table

9 个月前
The best way to get the first and last day of last month?

1 年前
Using WITH NOLOCK Table Hint in Query Using View - Does it Propagate Within the View?

1 年前