sql 일주일간 검색

SELECT * FROM `ranking` WHERE date > (curtime() - INTERVAL 7 DAY)

https://webisfree.com/2016-05-09/[mysql]-%EB%82%A0%EC%A7%9C-%EC%9D%B4%EC%A0%84-%EB%98%90%EB%8A%94-%EC%9D%B4%ED%9B%84-%EB%B3%B4%EC%97%AC%EC%A3%BC%EB%8A%94-%EC%BF%BC%EB%A6%AC%EB%AC%B8