查从昨天起 到一年前的数据 sql
select * from test where perate_date between DATE_SUB(NOW(), INTERVAL 365 DAY) and DATE_SUB(NOW(), INTERVAL 1 DAY)
查从昨天起 到一年前的数据 sql
select * from test where perate_date between DATE_SUB(NOW(), INTERVAL 365 DAY) and DATE_SUB(NOW(), INTERVAL 1 DAY)