[Mysql] calculates the item that is different from the last X days, and compares the date with the SQL statement.

[Mysql] calculates the item that is different from the last X days, and compares the date with the SQL statement.

For the following testtable table

Use the following SQL statement:

Select * from testtablewheretimestampdiff (year, date, now () <30

In this method, the query is successful even if the date field is of the varchar type. <Strong? Http: www.bkjia.com kf ware vc "target =" _ blank "class =" keylink "> VcD4KPHA + records + 8wse1vTE5ODXA68/W1NrP4LLuMzDE6qOsy + records/records = "brush: SQL;"> select * from testtablewhere date> '2017-1-1'