Mysql Date search

i was adding the option to my site Games Heaven [https://gamesheaven.wtnet9.site/] that now you can select how many days back posts should be visable i found out that mysql has inbuild feature to select date was very easy to setup